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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
MauStrQua
Contributor II
Contributor II

Filter highest operation

Hello together

I have a column with operations and articles. Each item has several operations. Now I want to filter the highest operation for each item. I have already made tests with "max(operation)" as filter, unfortunately without success.

Below is an example:
I only want to see the operation 70 of the article "y", but I do not want to set the filter to fixed 70, but to the highest operation per article.

Thanks already

Operation Article Order
30 y a
70 y b
30 x c
30 x b
70 y a
Labels (1)
2 Replies
BrunPierre
Partner - Master II
Partner - Master II

Like this?

Aggr(Max(Operation),Article)
Vishal_Gupta
Partner - Creator
Partner - Creator

Hi @BrunPierre,

Your solution seems to be working. Would request @MauStrQua to test it out and confirm.

If a post helps to resolve your issue, please accept it as a SOLUTION and leave a LIKE!