https://community.qlik.com/t5/App-Development/Application-Development/m-p/2028534#M84744 <P>Hey again Rob</P> <P>all is well... your suggestion worked</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nicouek_0-1674367980890.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/98565i74E80598AA7DD657/image-size/medium?v=v2&amp;px=400" role="button" title="nicouek_0-1674367980890.png" alt="nicouek_0-1674367980890.png" /></span></P> <P>Thank you very much</P> Sun, 22 Jan 2023 06:14:12 GMT nicouek 2023-01-22T06:14:12Z https://community.qlik.com/t5/App-Development/Application-Development/m-p/2028497#M84739 <P>Hello,</P> <P>I have a table:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nicouek_0-1674294562256.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/98558i5269AB328BC2C7F1/image-size/medium?v=v2&amp;px=400" role="button" title="nicouek_0-1674294562256.png" alt="nicouek_0-1674294562256.png" /></span></P> <P>&nbsp;</P> <P>I am trying to show and list the highest sales amount for each [ORDER_ID]</P> <P>(In other words: List all [ORDER_ID] highest [SALES]</P> <P>Thank you</P> Sat, 21 Jan 2023 09:53:06 GMT https://community.qlik.com/t5/App-Development/Application-Development/m-p/2028497#M84739 nicouek 2023-01-21T09:53:06Z https://community.qlik.com/t5/App-Development/Application-Development/m-p/2028524#M84742 <P>How about using&nbsp;</P> <P><FONT face="courier new,courier">Max(SALES)</FONT></P> <P>as the measure?</P> <P>-Rob<BR /><A href="http://www.easyqlik.com" target="_blank">http://www.easyqlik.com</A><BR /><A href="http://masterssummit.com" target="_blank">http://masterssummit.com</A><BR /><A href="http://qlikviewcookbook.com" target="_blank">http://qlikviewcookbook.com</A></P> Sat, 21 Jan 2023 17:28:26 GMT https://community.qlik.com/t5/App-Development/Application-Development/m-p/2028524#M84742 rwunderlich 2023-01-21T17:28:26Z https://community.qlik.com/t5/App-Development/Application-Development/m-p/2028532#M84743 <P>Thank you Rob,&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nicouek_0-1674364724884.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/98564iDE35C38C803F1BF2/image-size/medium?v=v2&amp;px=400" role="button" title="nicouek_0-1674364724884.png" alt="nicouek_0-1674364724884.png" /></span></P> <P>The solution did not quite work; my desired result will only display the ORDER_ID "occurrence" that has the highest SALES in blue.</P> <P>Thank you for the input.</P> Sun, 22 Jan 2023 05:24:00 GMT https://community.qlik.com/t5/App-Development/Application-Development/m-p/2028532#M84743 nicouek 2023-01-22T05:24:00Z https://community.qlik.com/t5/App-Development/Application-Development/m-p/2028534#M84744 <P>Hey again Rob</P> <P>all is well... your suggestion worked</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nicouek_0-1674367980890.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/98565i74E80598AA7DD657/image-size/medium?v=v2&amp;px=400" role="button" title="nicouek_0-1674367980890.png" alt="nicouek_0-1674367980890.png" /></span></P> <P>Thank you very much</P> Sun, 22 Jan 2023 06:14:12 GMT https://community.qlik.com/t5/App-Development/Application-Development/m-p/2028534#M84744 nicouek 2023-01-22T06:14:12Z