topic Re: YTD Calculation in QlikView

YTD Calculation

qlikapple — Sat, 16 Nov 2024 01:15:22 GMT

Hi all ,

I have Month column as Aug-19, Sep-19......Jan-20.

Now I have taken dimension month as Month and expression as Count(sales)

Nowi need to show as YTD calculation , how to do ? can anyone please help

Re: YTD Calculation

Taoufiq_Zarra — Tue, 18 Feb 2020 12:37:11 GMT

depending on the case 🙂

for me there is only one YTD e.g. for your case count (Sales) from the current year i.e. 2020 until the last Sales in the current year (today)

I have met other people with a different meaning of YTD !!

so to secure your loading I suggest you to add in the loading script

load ... Date(Date#(MonthYear,'MMM-YY'),'MMM-YY') as Month, ..

MonthYear is a field with Aug-19, Sep-19......Jan-20.

So the YTD :

=count({<Month= {">=$(=Date(Makedate(Year(today()),1,1),'MMM-YY'))<=$(=Date(today(),'MMM-YY'))"}> } Sales)

Re: YTD Calculation

Brett_Bleess — Tue, 24 Mar 2020 18:43:33 GMT

Did Taoufiq's post get you what you needed for your use case? If so, please do not forget to return to your thread and on his post, use the Accept as Solution button to mark that as the solution to give him credit for the help and let other Members know that worked. If you did something else, consider posting that and then mark it, and if you are still working on things, please leave an update. We prefer to have posts properly closed out if they are solved, so please consider following up on things for us.

Regards,
Brett