Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
1655653
Contributor II
Contributor II

filter rows in table to get only the first by column value

I have a table composed as follows

name | YEAR | sum(salesbyYear)

 

and i want to have as result, for each Year, the sum of all sales. The problem is that i get every year for all the people.

so, instead of  something like

John | 2021 | 100

Jack |2020 | 300

Mike|2019| 300

i get something like:

John |2021| 100

Jack |2021 | 3

Mike |2021| 5

Jack |2020| 300

...

Any helps?

Labels (3)
0 Replies