YTD Calculations

[aarohipatel]

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]

See attached for resolution of your problem.

Output : 

[aarohipatel]

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 · Accepted solution]

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.