QlikView Essentials

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