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
   Sum(LineSalesAmount) * (1 – Discount)  -   Label as Original Sale Amount

5. Create a new object by selecting Slider/Calendar from the list of new sheet objects.

6. On the General tab, the input style options are Slider and Calendar. Select Slider...