Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
NemoAndStitch22
New Contributor III

Year to date Prior Year formula

Hiya, 

 

I'm well aware that this has been asked many many times, however when searching for the answer I can't find an answer that is working for me.

I have full 2018 data and need to do 2018 YTD but to prior month. 

My data is loaded in on the 1st of the month for the prior month. So at the moment the data goes up to August 2019. 

I need to be able to compare this to August 2018 without selecting the months and have it automatically roll forward each month.

Currently the formulas I've found and have been trying are: 

clipboard_image_0.png

 

I can't get any of them to work for my app. 

 

Please could someone help and let me know where I'm going wrong?

 

I don't want to create a master calendar in the script if possible.

Thanks!!!

Megan