topic Re: Rank top 30% in expression in QlikView https://community.qlik.com/t5/QlikView/Rank-top-30-in-expression/m-p/764691#M1038521 <HTML><HEAD></HEAD><BODY><P>Something like the attached?</P></BODY></HTML> Fri, 09 Jan 2015 17:42:05 GMT chrismarlow 2015-01-09T17:42:05Z Rank top 30% in expression https://community.qlik.com/t5/QlikView/Rank-top-30-in-expression/m-p/764690#M1038520 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm attempting to create an expression that will return a value of 1 if the Rank of the values in the expression is in the top 30% and 0 if it is not</P><P></P><P>The current expression returns the sum of sales for each employee and this is what the rank should be based upon.</P><P></P><P>Can someone please point me in the right direction,, how to write what expression(s), what function should be used?</P><P></P><P>Thanks in advance</P><P></P><P>Brian</P></BODY></HTML> Fri, 09 Jan 2015 17:30:07 GMT https://community.qlik.com/t5/QlikView/Rank-top-30-in-expression/m-p/764690#M1038520 2015-01-09T17:30:07Z Re: Rank top 30% in expression https://community.qlik.com/t5/QlikView/Rank-top-30-in-expression/m-p/764691#M1038521 <HTML><HEAD></HEAD><BODY><P>Something like the attached?</P></BODY></HTML> Fri, 09 Jan 2015 17:42:05 GMT https://community.qlik.com/t5/QlikView/Rank-top-30-in-expression/m-p/764691#M1038521 chrismarlow 2015-01-09T17:42:05Z Re: Rank top 30% in expression https://community.qlik.com/t5/QlikView/Rank-top-30-in-expression/m-p/764692#M1038522 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">Make sure your chart is sorted by sales in descending order, then perhaps this expression will work:</SPAN></P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">((</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">rangesum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">above</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Sales]</SPAN><SPAN style="font-size: 8pt;">),0,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">rowno</SPAN><SPAN style="font-size: 8pt;">())))&lt;(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Sales</SPAN><SPAN style="font-size: 8pt;">) * .3),1,0)</SPAN></P></BODY></HTML> Fri, 09 Jan 2015 17:58:44 GMT https://community.qlik.com/t5/QlikView/Rank-top-30-in-expression/m-p/764692#M1038522 jzimolong 2015-01-09T17:58:44Z Re: Rank top 30% in expression https://community.qlik.com/t5/QlikView/Rank-top-30-in-expression/m-p/764693#M1038523 <HTML><HEAD></HEAD><BODY><P>maybe here</P><P><A href="https://community.qlik.com/qlik-blogpost/3913">Recipe for an ABC Analysis</A></P></BODY></HTML> Fri, 09 Jan 2015 18:42:28 GMT https://community.qlik.com/t5/QlikView/Rank-top-30-in-expression/m-p/764693#M1038523 maxgro 2015-01-09T18:42:28Z