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?
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
One way is to create The As Of Table
Have a look at the below
Could you provide examples of script?