Cannot associate current month variable with data to calculate month on month changes
I am struggling to calculate the month on month and year on year shifts on Qlik Sense and it would be great to get some help. I have been searching around on the forums and this thread: Qlik Sense: Load Year & Month Variables | Qlik Community was very helpful in showing me to set:
LET vMonthCurrent = Month(Today());
LET vMonthPrevious = Month(MonthStart(Today())-1);
in the data load editor which lists out the correct months in variables:
Unfortunately I cannot seem to link this with my existing 'Date' column in my spreadsheet. It is formatted as a date in data manager but doesn't seem to link properly (this is when creating a master dimension as =vMonthPrevious):
When trying to just list the total number of 'page views' for last month I get the sum total when using this expression:
Has anyone got any ideas/advice on how to get this working?