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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial