What-If Analysis

In QlikView, What-If Analysis is implemented using sliders and input box. In What-if Analysis, users can adjust the value of variables and see the effect on the data set in the chart.

Using sliders, the user wants to see how their sales amount changes if they make changes to the discount:

  1. Go to the Variable Overview and create a variable vChangeAmount and set the value as .5.
  2. Copy the Comparative Analysis sheet and name it What-If Analysis. Remove the table from the sheet.
  3. Create a pivot table. Change the title to What-If Discount. Use ProductLineDesc and OrderID as dimensions.
  4. For creating an expression, use the following and provide a Number format:
    Sum(LineSalesAmount) - Label as Sales Amount Sum(Discount) - Label it as Discount ...

Get QlikView Essentials now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.