Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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