Qlik Community

Ask a Question

Qlik Sense App Development

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

Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Year to date Prior Year formula



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: 



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.



Labels (5)
0 Replies