topic YTD Calculations in QlikView

YTD Calculations

aarohipatel — Tue, 30 Apr 2019 19:35:46 GMT

Hi,

Can you please help me with the YTD calculations .

I am looking for the below chart in QlikView app. Attached is the app with sample data.

Please advise

Thank you very much

Qrishna — Tue, 30 Apr 2019 20:47:38 GMT

See attached for resolution of your problem.

Output :

aarohipatel — Tue, 30 Apr 2019 21:22:17 GMT

Hi Krishna,

Thank you for the quick response.

Next when we have 2019/04 and further months data and 2020 months data in future- how will this work?

I see that you have done manual coding for 2018 and 2019 in the script.

Thank you!

Qrishna — Tue, 30 Apr 2019 21:37:43 GMT

The Manual Coded field was for my Analysis. you can ignore it.The rest of the code is good for all years. Pl Check Attached.