Hello All,
I am new to qlik.
I need to calculate YTD, 12RM and max month.
Sample data is
Year | Month | Amount |
2018 | Jan | 1000 |
2018 | Feb | 2000 |
2018 | Mar | 5000 |
2018 | Apr | 100 |
2018 | May | 200 |
2018 | June | 5555 |
2018 | July | 789 |
2018 | Aug | 789 |
2018 | Sep | 598 |
2018 | Oct | 432 |
2018 | Nov | 1000 |
2018 | Dec | 789 |
2019 | Jan | 56000 |
2019 | Feb | 6888 |
2019 | Mar | 98222 |
2019 | Apr | 2344 |
2019 | May | 982 |
2019 | Jun | 765 |
2019 | Jul | 951 |
2019 | Aug | 287 |
2019 | Sep | 999 |
2019 | Oct | 876 |
2019 | Nov | 129 |
2019 | Dec | 1244 |
Need to provide to filters to user Month Year & Year .
Problem:
- calculated 12RM but when i set the year filter to maximum i.e year 2020, the value becomes zero .
I thought to remove the Year filter and use only month year filter where maximum month year is always selected. It worked for rolling 12 months . But when tried to create YTD in bar chart, it shows only the value of current month year selected and does not show the data for all the years.
Please help.
Thanks
-YTD