topic Ranking problem when selecting in QlikView https://community.qlik.com/t5/QlikView/Ranking-problem-when-selecting/m-p/389556#M485889 <HTML><HEAD></HEAD><BODY><P>I am using the expression below, which give me the ranking, but if I make a selection, that fleet will allways be 1.&nbsp; </P><P></P><P>aggr</P><P>(</P><P><SPAN style="color: #0000ff; font-size: 8pt;">rank</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: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Fleet</SPAN><SPAN style="font-size: 8pt;">= {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"=aggr(sum(total &lt;Fleet, PERIOD&gt; {&lt;TOTAL = {'&gt;=$(Limit)&lt;=$(Capped)'}&gt;} YEARS ), Fleet) &gt; $(vyears)"</SPAN><SPAN style="font-size: 8pt;">}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;">/ </SPAN><SPAN style="color: #800000; font-size: 8pt;">YEARS</SPAN><SPAN style="font-size: 8pt;">)), </SPAN><SPAN style="color: #800000; font-size: 8pt;">Fleet</SPAN></P><P><SPAN style="font-size: 8pt;">)</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">But if I am using Fleet= in the Set Analysis expression, it will give me the rank of all the fleets corresponding to the current selection. </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">How could I use a condition, but still get the ranking when one fleet is selected?</SPAN></P><P><SPAN style="font-size: 8pt;"><BR /> </SPAN></P></BODY></HTML> Tue, 23 Apr 2013 09:45:39 GMT 2013-04-23T09:45:39Z Ranking problem when selecting https://community.qlik.com/t5/QlikView/Ranking-problem-when-selecting/m-p/389556#M485889 <HTML><HEAD></HEAD><BODY><P>I am using the expression below, which give me the ranking, but if I make a selection, that fleet will allways be 1.&nbsp; </P><P></P><P>aggr</P><P>(</P><P><SPAN style="color: #0000ff; font-size: 8pt;">rank</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: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Fleet</SPAN><SPAN style="font-size: 8pt;">= {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"=aggr(sum(total &lt;Fleet, PERIOD&gt; {&lt;TOTAL = {'&gt;=$(Limit)&lt;=$(Capped)'}&gt;} YEARS ), Fleet) &gt; $(vyears)"</SPAN><SPAN style="font-size: 8pt;">}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;">/ </SPAN><SPAN style="color: #800000; font-size: 8pt;">YEARS</SPAN><SPAN style="font-size: 8pt;">)), </SPAN><SPAN style="color: #800000; font-size: 8pt;">Fleet</SPAN></P><P><SPAN style="font-size: 8pt;">)</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">But if I am using Fleet= in the Set Analysis expression, it will give me the rank of all the fleets corresponding to the current selection. </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">How could I use a condition, but still get the ranking when one fleet is selected?</SPAN></P><P><SPAN style="font-size: 8pt;"><BR /> </SPAN></P></BODY></HTML> Tue, 23 Apr 2013 09:45:39 GMT https://community.qlik.com/t5/QlikView/Ranking-problem-when-selecting/m-p/389556#M485889 2013-04-23T09:45:39Z