Interview Questions for Qlikview Designer-2

Question.1 What is calculated dimension?

Answer: Charts in QlikView require dimensions. Dimensions provide context to measure or expressions. Sometimes these dimensions exist in the data and sometimes need to be calculated. Such dimensions are called calculated dimensions. Calculated dimensions are created in the chart, by using “Add Calculated Dimension” or by simply editing the existing dimension. The calculated dimension can be an expression using conditional statements and functions.

Question.2 What are synthetic dimensions?

Answer: Synthetic dimensions are the dimensions which are created by the developer using the synthetic functions. These dimensions are not based on the fields present in the data model.
ValueList and ValueLoop functions are used to create Synthetic dimensions.

Question.3 What are triggers in QlikView desktop?

Answer:

Triggers are used to set Action on an event. These Actions execute when a specific condition is met.
Trigger types are Document event trigger, Field event trigger and variable event trigger.
The trigger is configured from menu Settings/Document properties and selecting Triggers tab.

Question.4 My dashboard uses TestTable data. I have a list box for a Product, with values Shirt, Pant and Socks. Create a functionality where clicking on a text object, a selection for “Pant” is made in the Product list box

Answer:

  • Right click on the dashboard screen, select New Sheet Object and create a Text object. Label it “Select a Product”
  • Go to Text object properties and navigate to Actions tab.
  • Click on Add and under Action Type, select Selection and in the Action selection Select in the field
  • In the Field edit box, type Product and in the Search string edit box type Pant Click ok
  • Now the Text object will behave like a button and clicking on it will select “Pant” in the Product list box.

Question.5 Use TestTable data. In a straight table, If Amount is below or equal to 200 display it in red and if Amount is above 200, display it in green

Answer: Create a straight table with a required dimension and expression. In the expression for Sum (Amount), collapse the expression by clicking on the + sign on the left. It will open up options for background color, text color and so on. Write following expressions for Text color

If (Sum (Amount) >200, Green (), Red ())

Question.6 What are mini charts and how to create them?

Answer: Mini charts are charts which are displayed per row in a straight table. These are created by navigating to the expressions tab in straight table and selecting Representation as Mini Chart under Display Options.

Question.7 Which chart has only expression and is not affected by dimension?

Answer: Gauge chart. Dimension in a gauge chart will have no effect on the chart. Dimension is not required.

Question.8 How you will create an application for mobile devices like iPad?

Answer: QlikView does not have any specific objects for iPad. For iPad, a dashboard should be developed using the same objects, but for a different screen resolution. The focus should be given to objects that will be more visible on iPad. For e.g. containers should be used instead of displaying charts separately.

Question.9 Explain Aggr function?

Answer: Aggr function comes under advanced aggregation in QlikView. It allows aggregation over
dimensions. It is similar to Group By in SQL. Aggr function is also required if nested
aggregation functions are used in an expression.

Question.10 Using TestTable data, write Aggr function expression that will group Sum (Amount) by
Product and Year

Answer:

  • Create a straight table, with dimensions as ID, Name, Product and Year.
  • In expression, specify

Aggr(Sum(Amount),Year, Product)