O'Reilly logo

QlikView Essentials by Chandraish Sinha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required