topic Re: Script using Flag in QlikView

Script using Flag

poooja — Tue, 12 Mar 2019 19:20:22 GMT

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

Re: Script using Flag

techvarun — Wed, 13 Mar 2019 05:59:13 GMT

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)

Re: Script using Flag

Brett_Bleess — Wed, 20 Mar 2019 18:10:39 GMT

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=false&collapse_discussion=true&filter=location&location=blog-board:qlik-design-blog&q=flag&search_type=thread

Regards,
Brett