topic Re: How to Rank Top X Measures in QlikView https://community.qlik.com/t5/QlikView/How-to-Rank-Top-X-Measures/m-p/480480#M1144995 <HTML><HEAD></HEAD><BODY><P>Great, thank you. </P></BODY></HTML> Sun, 11 Aug 2013 04:12:58 GMT 2013-08-11T04:12:58Z How to Rank Top X Measures https://community.qlik.com/t5/QlikView/How-to-Rank-Top-X-Measures/m-p/480476#M1144991 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to rank top 2 measures (see attched). Unfortunately, I am not allowed to crosstable the data and convert the measures into dimension, and so I am not sure how to apply "normal" aggr(if(rank(sum(VALUE))...</P><P></P><P>Any help will be appreciated. </P></BODY></HTML> Fri, 09 Aug 2013 08:30:53 GMT https://community.qlik.com/t5/QlikView/How-to-Rank-Top-X-Measures/m-p/480476#M1144991 2013-08-09T08:30:53Z Re: How to Rank Top X Measures https://community.qlik.com/t5/QlikView/How-to-Rank-Top-X-Measures/m-p/480477#M1144992 <HTML><HEAD></HEAD><BODY><P>can you use this in anyway.</P><P></P><P>rank</P><P><SPAN style="font-size: 8pt;">( </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">pick</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">match</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">d</SPAN><SPAN style="font-size: 8pt;">,'M1','M2','M3','M4')<BR /><BR />,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">M1</SPAN><SPAN style="font-size: 8pt;">)<BR /><BR />,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">M2</SPAN><SPAN style="font-size: 8pt;">)<BR /><BR />,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">M3</SPAN><SPAN style="font-size: 8pt;">)<BR /><BR />,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">M4</SPAN><SPAN style="font-size: 8pt;">)<BR /><BR />),3,0) </SPAN></P><P></P></BODY></HTML> Fri, 09 Aug 2013 11:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-Rank-Top-X-Measures/m-p/480477#M1144992 Tammy_Milsom 2013-08-09T11:16:04Z Re: How to Rank Top X Measures https://community.qlik.com/t5/QlikView/How-to-Rank-Top-X-Measures/m-p/480478#M1144993 <HTML><HEAD></HEAD><BODY><P>Hi tmm,</P><P></P><P>this is helpful, but how do I display top 2 measure? I cannot seem to get the expression below to work.</P><P></P><P>=aggr(if(rank(pick(match(d,'M1','M2','M3','M4')</P><P>,sum(M1)</P><P>,sum(M2)</P><P>,sum(M3)</P><P>,sum(M4)</P><P>),3,0)&lt;=2,d),d)</P></BODY></HTML> Sat, 10 Aug 2013 06:51:27 GMT https://community.qlik.com/t5/QlikView/How-to-Rank-Top-X-Measures/m-p/480478#M1144993 2013-08-10T06:51:27Z Re: How to Rank Top X Measures https://community.qlik.com/t5/QlikView/How-to-Rank-Top-X-Measures/m-p/480479#M1144994 <HTML><HEAD></HEAD><BODY><P>Maybe like attached, using</P><P></P><P>=aggr(if(rank(pick(match(d,'M1','M2','M3','M4')</P><P>,sum(M1)</P><P>,sum(M2)</P><P>,sum(M3)</P><P>,sum(M4)</P><P>),3,0)&lt;=2,d)<STRONG>,Dim_01</STRONG>,d)</P></BODY></HTML> Sat, 10 Aug 2013 13:09:45 GMT https://community.qlik.com/t5/QlikView/How-to-Rank-Top-X-Measures/m-p/480479#M1144994 swuehl 2013-08-10T13:09:45Z Re: How to Rank Top X Measures https://community.qlik.com/t5/QlikView/How-to-Rank-Top-X-Measures/m-p/480480#M1144995 <HTML><HEAD></HEAD><BODY><P>Great, thank you. </P></BODY></HTML> Sun, 11 Aug 2013 04:12:58 GMT https://community.qlik.com/t5/QlikView/How-to-Rank-Top-X-Measures/m-p/480480#M1144995 2013-08-11T04:12:58Z