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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
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
Partner Ambassador/MVP
Partner Ambassador/MVP

3 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/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