Discussion board where members can get started with Qlik Sense.
As I'm new to Qlik Sense, can I please get some help on the following issue in Qlik Sense:
I created a table that has a single column dimension such as:
I then want to create a measure that calculate the sales of the previous year (which I do have in my loaded data) corresponding to the dimension so that it looks like this:
Thanks for reading and helping out. Cheers.
You'll need a table that links each month with the month of the year before.
LOAD Distinct MonthYear as ReportMY, MonthYear, 'Current' as Period
LOAD Distinct MonthYear as ReportMY, date(AddYears(MonthYear, -1),'MMM-YY') as MonthYear, 'Previous' as Period
The above assumes you've already turned the MonthYear field in a date field formatted in the MMM-YY format (or created a MonthYear field from your source field using the date# and date functions.
Thanks for the help Gysbert. Cheers!