Point in Time using Set Analysis

"How is this month looking compared to the last?" This is one of the most common questions asked in BI solutions. In this recipe, we will build two charts and both will compare one year to another. The first chart expression will limit the range of data and make use of the Year dimension. The second chart will not use the Year dimension but will build the year comparison directly into the expression itself.

 

 

Getting ready

For the purpose of this recipe, we will make use of an inline data load that gives yearly sales information for different fruits. Load the following data into the Qlik Sense Data load editor:

Data:  
LOAD * INLINE [ 
    Fruit, Year, Sales 
    Apple, 2013, 63 
    Apple, 2014, 4 
    Cherry, 2014, 1150 
    Cherry, 2013, 1180 
    Fig, 2013, 467 
    Fig, 2013, 374 
    Fig, 2014, 162 
    Fig, 2014, 267 
    Fig, 2014, 586 
    Orange, 2013, 10 
    Orange, 2013, 50 
    Orange, 2013, 62 
    Orange, 2013, 131 
    Orange, 2013, 145 
  ...