Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

MTD and YTD Caluclation for Weeeks

Hi All,

I have a situation where i need to calculate MTD and YTD based on weeks. I'm using Fiscal Calendar and my weeks are also

created based on date ranges.

W1,W2,W3,W4,W5 are calculated as Sales/Qty.

Based on the week values , i have to go with creating MTD for that Month and for subsequent months too and finally YTD from Apr to till date.


Please find the screenshot for the same.



Any example code snippet or links would be a great help.






Srinivas K 

Labels (2)
0 Replies