Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i was able to find the rolling current year and last year calculation in a text, but i'm not able to do so for ytd. can someone please help me on this.
='Current Year:'& Num((Sum({<week = {">=$(vMinDate)<=$(vMaxdate)"}>} NET_SLS_AMT)/1000000),'##.00')
& ' Last Year:'&num((((Sum({<week = {">=$(vRollingStart)<=$(vRollingEnd)"},Period=>} NET_SLS_AMT)/1000000)
-
Sum({<week = {">=$(vRollingStart)<=$(vRollingEnd)"},Period= {'LYTD'}> } NET_SLS_AMT)/1000000)),'##.00')
this code is for Rolling current and rolling last year calculation and i have two filter called view and period, and i want the same for tyd current and last year in the same text object. please help me on this, i got to deliver tomorrow.
The only thing I have is the following Design Blog post that may further help:
https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511
Here is the base URL for the Design Blog in case you wish to further search for other posts, there are hundreds in this area, just FYI and majority are how-to related...
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett