Script using Flag

[poooja]

Hi Qliks,

I am working on a project that requires me to To calculate MTD,PYMTD,QTD,PYQTD,YTD,PYYTD.I am trying to achevie this by writing the Script using Flag and not by creating Variables. Autocalendas flags(InMtd) are not working for MTD.Anyone have any ideas on how I can accomplish this? Thanks in advance.

Thanks!

Pooja

[techvarun]

Hi In Your Master calendar you need to create a flag isYTD for all the YTD entries and you can simply write a expression something like

=Sum(Qty*isYTD)

[Brett_Bleess]

Have a look at the following Design Blog post from Henric Cronstrom, may not be exactly what you want, but may give you some other ideas, and you can search through other posts in the Blog as well, there were more, but I grabbed this one thinking it was closest to what you were trying to do.  This is along the lines of what the above posted noted, but this provides a bit more context for you.

https://community.qlik.com/t5/Qlik-Design-Blog/Year-over-Year-Comparisons/ba-p/1462927?advanced=fals...

Regards,
Brett