Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Tatynout
Contributor III
Contributor III

MTD(Month To Date) calculation in script

Good day, 

I would like to make a MTD (monthly to date) calculation of data by cumulating monthly data from 2018 in QS script. 

Here is an example of the calculation in Excel:

Tatynout_0-1619622244389.png

 

Here is how the data should be represented in QS for every year:

Tatynout_1-1619622719110.png

 

I please need  help to calculate my  MTD field into QlikSense script. 

 

I have attached the excel file to this post.

 

Thanks for your help.

 

Tatiana

 

 

0 Replies