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.
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:
Comparative Analysisand remove the two tables from the sheet.
Product Line. Check Suppress When Value is Null.