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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
nicouek
Creator
Creator

Application Development

Hello,

I have a table:

nicouek_0-1674294562256.png

 

I am trying to show and list the highest sales amount for each [ORDER_ID]

(In other words: List all [ORDER_ID] highest [SALES]

Thank you

Labels (1)
1 Solution

Accepted Solutions
rwunderlich
MVP
MVP

3 Replies
rwunderlich
MVP
MVP

How about using 

Max(SALES)

as the measure?

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

nicouek
Creator
Creator
Author

Thank you Rob, 

nicouek_0-1674364724884.png

The solution did not quite work; my desired result will only display the ORDER_ID "occurrence" that has the highest SALES in blue.

Thank you for the input.

nicouek
Creator
Creator
Author

Hey again Rob

all is well... your suggestion worked

nicouek_0-1674367980890.png

Thank you very much