Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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
Partner - Master

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!