Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a table:
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
How about using
Max(SALES)
as the measure?
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
How about using
Max(SALES)
as the measure?
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
Thank you Rob,
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.
Hey again Rob
all is well... your suggestion worked
Thank you very much