Question.1 How dimensions are displayed on a QlikView dashboard?

Answer: List box and Multi box can be created on a dashboard to display dimensions.

Question.2 What Chart types are available in QlikView?

Answer:  QlikView provides different kinds of visualization objects. Some of the charts which can be used are

• Bar chart. For comparing data elements over dimension/s. Bar charts can also be
  stacked.
• Line Chart. To display the trend of measure over time use Line chart.
• Combo chart. It is a combination of bar and line chart and is used to display two measures. One measure can be an amount and another percentage.
• Straight table. Used to show the dimensions and expressions.
• Pivot table. It is used to display dimension and expressions. Expressions are grouped by dimensions. It is similar to cross table. Pivot table can have subtotals.
• Scatter chart. Is used to display relationships between the data elements.
• Pie Chart. The pie chart is used to display the slices of the total.
• Mini charts. Mini charts or sparklines are used to show the trends. They are displayed for each row of the straight table and created in Straight table/expressions.
• Gauge chart. This chart is used to see if the measure falls within or outside a
  threshold.

Question.3 What data elements are required to create a chart?

Answer: Most of the charts require one or more dimensions and one or more expressions.

Question.4 How to create a simple bar chart

Answer:

• Load TestTable, if it’s not already loaded.
• Right click on the QlikView sheet. Select the option to create New Sheet Object
  and Chart.
• Bar chart is selected by default. Click next and select/add Year as dimension.
• Click next and specify Sum (Amount) as an expression and click finish.

Question.5 What is the difference between a Table box, Pivot and Straight table?

Answer:

• Table box can contain fields from one or multiple tables. Table box does not contain calculations.
• Straight table consists of a dimension and an expression. Straight tables have interactive sorting.
• Pivot table is similar to cross tables. They display dimensions and expressions in rows and columns. Pivot table is grouped by dimension.

Question.6 How to change the display of a chart by different dimensions?

Answer:  A chart can be seen by multiple unrelated dimensions by creating a cyclic group

Question.7 How to drill down from Year to Quarter and Month?

Answer: A drill down group can be created with the hierarchy as Year, Quarter and Month. Drill down group can be created within the chart or from the Settings/Document properties/Groups.

Question.8 How to perform Year by Year comparisons in dashboard?

Answer: Year to Year comparisons can be done using Set Analysis.

Question.9 What is comparative analysis and how it is implemented?

Answer: Comparative analysis involves comparing data between two time periods or two states.
Comparative analysis can be implemented using Set Analysis and Alternate state.

Question.10 What is Set Analysis?

Answer:

• The set Analysis expression is applied in the visualization objects, such as Charts and Text boxes.
• A QlikView document is always in the current state and performs aggregation of the records defined by the current selection.
• Set Analysis is used, any time aggregation is required for the records outside current selection.
• For e.g. the current selection will display Sum (Amount) for the selected year. Use Set Analysis expression, if you want Sum (Amount) for the previous year, next Year or specific Year.
• In the absence of Set Analysis, use of complex if then else statement will be required.
• Set Analysis expression starts and ends with a curly bracket.
•  Set Analysis has 3 components – Identifiers, Modifiers and operators.

Question.11 What are Identifiers in Set Analysis?

Answer:

• The identifier is one of the components in Set Analysis. Other two components are Modifier and Operator.
• Identifiers define a set or defines the scope of the expression. For example $ means current selection. 1 means entire dataset.
• When used in an expression for e.g.,
  Sum ({$} Amount) means Amount for the current selection. $ is optional and is always applied by default as it means current selection.
  Sum ({1} Amount) means total Amount for the entire data in an application. It will not consider the selection made in the list box but will honor the dimensions in the chart where it is used.

Question.12 What are modifiers?

Answer: A set can be modified by using Modifiers. It is used like a where clause. In the below example, modifier is used to display Amount where Product = Shirt

Sum ({} Amount)

Question.13 What is What-if analysis and how it is implemented?

Answer: What-if scenario involves accepting user input in the dashboard and changing the calculations based on user input. For e.g., a user wants to know at run time, if he changes the discount price how his overall profitability will change. User can enter different discount prices in the dashboard.
User input is accepted by using an input box, Slider and Input field.

Question.14 What is the use of Total Qualifier?

Answer: In a table/chart, the expression is always calculated by dimension.
By using Total Qualifier, you can ignore the dimension in the chart. If chart contains multiple dimensions and you want to include specific dimensions, specify those dimensions with Total.

Question.15 How variables are declared in QlikView?

Answer: 

• In QlikView, variables are declared using SET and LET statements.
• Variables can be declared in a script or from menu settings/Variable overview.
• SET statement is used to set a value of a variable. This can be used to define today’s date or path of a QVD, include files etc.
• The LET statement evaluates the expression on the right side of the = and assigns it to the variables. These variables are used for calculations.
• All defined variables can be seen in Variable Overview.