topic Re: Help with Rank in a set analysis in QlikView https://community.qlik.com/t5/QlikView/Help-with-Rank-in-a-set-analysis/m-p/1361689#M837903 <HTML><HEAD></HEAD><BODY><P>Might need a aggr here, but i'm not sure how to do a aggr within the rank</P></BODY></HTML> Wed, 17 May 2017 14:13:56 GMT 2017-05-17T14:13:56Z Help with Rank in a set analysis https://community.qlik.com/t5/QlikView/Help-with-Rank-in-a-set-analysis/m-p/1361686#M837900 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>For the chart, i just only to display the top 2 amount for each user, and only taking the amount when indicator =S. So something like sum({&lt;Indicator = {'S'}&gt;}Amount ).</P><P></P><P></P><P>Thanks</P><P>J</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Help-with-Rank-in-a-set-analysis/m-p/1361686#M837900 2020-11-25T16:16:04Z Re: Help with Rank in a set analysis https://community.qlik.com/t5/QlikView/Help-with-Rank-in-a-set-analysis/m-p/1361687#M837901 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/163745_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 17 May 2017 14:02:39 GMT https://community.qlik.com/t5/QlikView/Help-with-Rank-in-a-set-analysis/m-p/1361687#M837901 tresB 2017-05-17T14:02:39Z Re: Help with Rank in a set analysis https://community.qlik.com/t5/QlikView/Help-with-Rank-in-a-set-analysis/m-p/1361688#M837902 <HTML><HEAD></HEAD><BODY><P>Thanks Tresesco,</P><P></P><P>But i want it in a bar chart. can you help? e.g. a bar chart for User A with the top 2 value added together....</P></BODY></HTML> Wed, 17 May 2017 14:10:28 GMT https://community.qlik.com/t5/QlikView/Help-with-Rank-in-a-set-analysis/m-p/1361688#M837902 2017-05-17T14:10:28Z Re: Help with Rank in a set analysis https://community.qlik.com/t5/QlikView/Help-with-Rank-in-a-set-analysis/m-p/1361689#M837903 <HTML><HEAD></HEAD><BODY><P>Might need a aggr here, but i'm not sure how to do a aggr within the rank</P></BODY></HTML> Wed, 17 May 2017 14:13:56 GMT https://community.qlik.com/t5/QlikView/Help-with-Rank-in-a-set-analysis/m-p/1361689#M837903 2017-05-17T14:13:56Z Re: Help with Rank in a set analysis https://community.qlik.com/t5/QlikView/Help-with-Rank-in-a-set-analysis/m-p/1361690#M837904 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/163747_Capture.PNG" style="height: auto;" /></P><P><STRONG><EM>Sum({&lt;Indicator={S}&gt;}If(Aggr( Rank( Sum( {&lt;Indicator={S}&gt;} Amount)),UserName,Amount)&lt;3,Amount))</EM></STRONG></P></BODY></HTML> Wed, 17 May 2017 15:32:45 GMT https://community.qlik.com/t5/QlikView/Help-with-Rank-in-a-set-analysis/m-p/1361690#M837904 tresB 2017-05-17T15:32:45Z