
Creator II
2019-04-30
03:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
YTD Calculations
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
765 Views
1 Solution
Accepted Solutions


Master
2019-04-30
05:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
3 Replies


Master
2019-04-30
04:47 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
See attached for resolution of your problem.
Output :

Creator II
2019-04-30
05:22 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
747 Views


Master
2019-04-30
05:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
