https://community.qlik.com/t5/Connectivity-Data-Prep/Min-Or-Max-from-Rank-Measure/m-p/1840720#M9592 <P>Something like this may be -&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Digvijay_Singh_0-1633055558393.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/63106i76E4A390791EB323/image-size/medium?v=v2&amp;px=400" role="button" title="Digvijay_Singh_0-1633055558393.png" alt="Digvijay_Singh_0-1633055558393.png" /></span></P><P>&nbsp;</P> Fri, 01 Oct 2021 02:32:46 GMT Digvijay_Singh 2021-10-01T02:32:46Z https://community.qlik.com/t5/Connectivity-Data-Prep/Min-Or-Max-from-Rank-Measure/m-p/1840568#M9588 <P><SPAN>Hi Everyone,</SPAN></P><P><SPAN>Can we calculate Min or Max Rank from Rank measure in Qliksense. I am struggling on this since last 2 weeks as I am just starter for Qliksense.</SPAN></P><P><SPAN>Example below</SPAN></P><P><SPAN>Product_Col&nbsp; &nbsp;Sales_Col&nbsp; &nbsp;Rank_Product&nbsp; &nbsp;Rank_Product_%</SPAN></P><P><SPAN>Product&nbsp; A&nbsp; &nbsp; &nbsp; &nbsp;40000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;33%&nbsp; (1/3)</SPAN></P><P><SPAN>Product B&nbsp; &nbsp; &nbsp; &nbsp;35000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;67%&nbsp; (2/3)</SPAN></P><P><SPAN>Product C&nbsp; &nbsp; &nbsp; &nbsp;22000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100%&nbsp;(3/3)</SPAN></P><P>&nbsp;</P><P><SPAN>Last columns I want to calculate like&nbsp; &nbsp; &nbsp;Rank_Product&nbsp; &nbsp;/&nbsp; Max(Rank_Product&nbsp;)</SPAN></P><P>&nbsp;</P><P><SPAN>Please help!</SPAN></P><P>&nbsp;</P><P><SPAN>Thanks,</SPAN></P><P><SPAN>Anshu</SPAN></P> Thu, 30 Sep 2021 14:20:17 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Min-Or-Max-from-Rank-Measure/m-p/1840568#M9588 Anshu_Saxena 2021-09-30T14:20:17Z https://community.qlik.com/t5/Connectivity-Data-Prep/Min-Or-Max-from-Rank-Measure/m-p/1840720#M9592 <P>Something like this may be -&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Digvijay_Singh_0-1633055558393.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/63106i76E4A390791EB323/image-size/medium?v=v2&amp;px=400" role="button" title="Digvijay_Singh_0-1633055558393.png" alt="Digvijay_Singh_0-1633055558393.png" /></span></P><P>&nbsp;</P> Fri, 01 Oct 2021 02:32:46 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Min-Or-Max-from-Rank-Measure/m-p/1840720#M9592 Digvijay_Singh 2021-10-01T02:32:46Z