Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
kasiugaa
Contributor
Contributor

Show sum of sale for last available month for each year

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. 

Labels (1)
3 Replies
parevrac
Contributor III
Contributor III

Have you tried using the aggr function Sum of rows in pivot tables ‒ QlikView

in this case "max(aggr(max(Sales),Year))"

kasiugaa
Contributor
Contributor
Author

It is not working - No data to display

parevrac
Contributor III
Contributor III

Have a look at the attached example