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.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
KundanJyothsna
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.

KundanJyothsna_0-1613626183651.png

 

 

 

Regards,

Srinivas K 

Labels (2)
0 Replies