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

Using Set Analysis

We will perform a few Set Analysis expressions to understand the power of Set Analysis. It is important for the Adventure Works company to perform a year-by-year comparison of sales. It will help them in asking questions about the years when sales went down and look for the reasons.

Use QlikEssentials_Presentation.qvw for this example. Navigate to the Using Functions tab, right click on any empty space, and select Copy Sheet. This will create a copy of the sheet:

  1. Modify the title of the sheet as Comparative Analysis and remove the two tables from the sheet.
  2. Create a straight table. Select ProductLineDesc as a dimension and label it as Product Line. Check Suppress When Value is Null.
  3. Create an expression for sales for the year 2006. ...

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