YTD calulation

swapnilgupta — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: YTD calulation

Brett_Bleess — Mon, 23 Dec 2019 19:59:28 GMT

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

topic Re: YTD calulation in QlikView

YTD calulation

Re: YTD calulation