Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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