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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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