topic Re: Ranking in a table in QlikView https://community.qlik.com/t5/QlikView/Ranking-in-a-table/m-p/1438055#M431790 <HTML><HEAD></HEAD><BODY><P>What is your dimension and expressions here? May be use conditional show here:</P><P></P><P>1st expression conditional Show</P><P>RangeMin(Exp1, Exp2, Exp3, Exp4, Exp5) &lt;= Exp1</P><P></P><P style="font-size: 13.3333px;">2nd expression conditional Show</P><P style="font-size: 13.3333px;">RangeMin(Exp1, Exp2, Exp3, Exp4, Exp5) &lt;= Exp2</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">3rd expression conditional Show</P><P style="font-size: 13.3333px;">RangeMin(Exp1, Exp2, Exp3, Exp4, Exp5) &lt;= Exp3</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">4th expression conditional Show</P><P style="font-size: 13.3333px;">RangeMin(Exp1, Exp2, Exp3, Exp4, Exp5) &lt;= Exp4</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">5th expression conditional Show</P><P style="font-size: 13.3333px;">RangeMin(Exp1, Exp2, Exp3, Exp4, Exp5) &lt;= Exp5</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Replace Exp1, Exp2, .... , Exp5 with the original expressions</P></BODY></HTML> Tue, 05 Sep 2017 17:29:49 GMT sunny_talwar 2017-09-05T17:29:49Z Ranking in a table https://community.qlik.com/t5/QlikView/Ranking-in-a-table/m-p/1438054#M431789 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-family: Garamond; font-size: 12pt;">Hi</SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-family: Garamond; font-size: 12pt;">I have built a table that look like this.</SPAN></P><P></P><P><SPAN style="color: #000000; font-family: Garamond; font-size: 12pt;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/175598_pastedImage_3.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-family: Garamond; font-size: 12pt;">My client want me to only show the three question with lowest %. Is that possible?</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P></BODY></HTML> Tue, 05 Sep 2017 12:17:39 GMT https://community.qlik.com/t5/QlikView/Ranking-in-a-table/m-p/1438054#M431789 asa_runstrom 2017-09-05T12:17:39Z Re: Ranking in a table https://community.qlik.com/t5/QlikView/Ranking-in-a-table/m-p/1438055#M431790 <HTML><HEAD></HEAD><BODY><P>What is your dimension and expressions here? May be use conditional show here:</P><P></P><P>1st expression conditional Show</P><P>RangeMin(Exp1, Exp2, Exp3, Exp4, Exp5) &lt;= Exp1</P><P></P><P style="font-size: 13.3333px;">2nd expression conditional Show</P><P style="font-size: 13.3333px;">RangeMin(Exp1, Exp2, Exp3, Exp4, Exp5) &lt;= Exp2</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">3rd expression conditional Show</P><P style="font-size: 13.3333px;">RangeMin(Exp1, Exp2, Exp3, Exp4, Exp5) &lt;= Exp3</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">4th expression conditional Show</P><P style="font-size: 13.3333px;">RangeMin(Exp1, Exp2, Exp3, Exp4, Exp5) &lt;= Exp4</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">5th expression conditional Show</P><P style="font-size: 13.3333px;">RangeMin(Exp1, Exp2, Exp3, Exp4, Exp5) &lt;= Exp5</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Replace Exp1, Exp2, .... , Exp5 with the original expressions</P></BODY></HTML> Tue, 05 Sep 2017 17:29:49 GMT https://community.qlik.com/t5/QlikView/Ranking-in-a-table/m-p/1438055#M431790 sunny_talwar 2017-09-05T17:29:49Z Re: Ranking in a table https://community.qlik.com/t5/QlikView/Ranking-in-a-table/m-p/1438056#M431791 <HTML><HEAD></HEAD><BODY><P>You might find some inspiration in this example:</P><P><SPAN>Qlikview Cookbook: Outliers </SPAN><A class="jive-link-external-small" href="http://qlikviewcookbook.com/recipes/download-info/outliers/" rel="nofollow" target="_blank">http://qlikviewcookbook.com/recipes/download-info/outliers/</A></P><P></P><P>-Rob</P><P><A class="jive-link-external-small" href="http://masterssummit.com" rel="nofollow" target="_blank">http://masterssummit.com</A></P><P><A class="jive-link-external-small" href="http://qlikviewcookbook.com" rel="nofollow" target="_blank">http://qlikviewcookbook.com</A></P></BODY></HTML> Tue, 05 Sep 2017 17:43:33 GMT https://community.qlik.com/t5/QlikView/Ranking-in-a-table/m-p/1438056#M431791 rwunderlich 2017-09-05T17:43:33Z