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:
- Go to the Variable Overview and create a variable
vChangeAmountand set the value as
- Copy the Comparative Analysis sheet and name it
What-If Analysis. Remove the table from the sheet.
- Create a pivot table. Change the title to
What-If Discount. Use
- For creating an expression, use the following and provide a Number format:
Sum(LineSalesAmount) - Label as Sales Amount Sum(Discount) - Label it as Discount ...