Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a End of Period data for Sale
2020 | 2021 | 2022 | |
Jan | 1 | 2 | 3 |
Feb | 4 | 5 | |
Mar | 6 | 7 | |
Apr | 8 | 9 | |
May | 10 | 11 | |
Jun | 12 | 13 | |
Jul | 14 | 15 | |
Aug | 16 | 17 | |
Sep | 18 | 19 | |
Oct | 20 | 21 | |
Nov | 22 | 23 | |
Dec | 24 | 25 |
I want to create a chart. Where I will show 24 for 2020. 25 for 2021 and 3 for 2022.
When user will choose only 2021 and 2022 I want to show on chart only 25 for 2021 and 3 for 2022.
If the user will choose November I want to show: 22 for 2020 and 23 for 2021.
It looks very easy, but I don't know what to do.
Have you tried using the aggr function Sum of rows in pivot tables ‒ QlikView
in this case "max(aggr(max(Sales),Year))"
It is not working - No data to display
Have a look at the attached example