what are the approches to follow YTD, MTD and QTD from backend?

[khasimvali85]

Hello All,

I have large data set in QlikSense (Millions of records), what are the approches to follow YTD, MTD and QTD from backend(Scripting Side) or UI Level?

Thanks,

Khasim.

[punitpopli]

u should get these as Flags from the back end and assign the value as "1" which will be easy to use.

like: YTD=1 for the period Jan-19 till today

MTD=1 for 1-Feb-19 till date

QTD =1 From Jan 19 till date

Hope this helps

[sunny_talwar]

One way is to create The As Of Table

[pradosh_thakur]

Have a look at the below

https://community.qlik.com/t5/QlikView-Documents/Date-Level-Analysis-WTD-MTD-QTD-YTD-Current-Year-Pr...

[roccosdg]

Could you provide examples of script?