Qlik Sense App: Prior Period Comparison with Set Analysis

[stevedark]

This document shows how Set Analysis can be used to create a prior period comparison that is responsive to your current selections.

The expressions can be applied to any data set where you have your main date field broken out into Day, Month and Year fields.

This application is a Qlik Sense version of the QlikView app that has been uploaded to Community here:

QlikView App: Set Analysis - Prior Period Comparison

There is further discussion on the app and technique in the comments there (including some important notes about when your data set doesn't have values for all dates).

There are a number of other tutorials and downloadable examples on our website here:

https://www.quickintelligence.co.uk/qlikview-examples/

If you have any questions please post them in the comments below.

Steve Dark

http://www.quickintelligence.co.uk/

[stevedark]

Hi @dwighttrumbower 

Thanks for your comment. Hopefully you should be able to suss out quarters as well.

The thing to note is that there is no quarter function, so you need to calculate quarters thus:

'Q' & ceil(Month(Date)/3) as Quarter,
(Year(Date)*100) + ceil(Month(Date)/3) as [Year Quater],

Or similar, depending how you want things to appear.

Good luck!