topic Color top 5 in a straight table with 2 dimensions in QlikView https://community.qlik.com/t5/QlikView/Color-top-5-in-a-straight-table-with-2-dimensions/m-p/1036937#M928214 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I want to create a straight table with all observations. The first 5 observations should be coloured based on 5 highest values.</P><P>this is the screenshot:<IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/118786_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>When I have defined only one dimension in the table, then everything works fine.</P><P>However, not for two dimensions.</P><P>In addition, the table is not correctly sorted.</P><P>Do you see any solution?</P><P></P><P>Thanks and best regards,</P><P></P><P>Cornelis.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Color top 5 in a straight table with 2 dimensions https://community.qlik.com/t5/QlikView/Color-top-5-in-a-straight-table-with-2-dimensions/m-p/1036937#M928214 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I want to create a straight table with all observations. The first 5 observations should be coloured based on 5 highest values.</P><P>this is the screenshot:<IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/118786_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>When I have defined only one dimension in the table, then everything works fine.</P><P>However, not for two dimensions.</P><P>In addition, the table is not correctly sorted.</P><P>Do you see any solution?</P><P></P><P>Thanks and best regards,</P><P></P><P>Cornelis.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Color-top-5-in-a-straight-table-with-2-dimensions/m-p/1036937#M928214 2020-11-25T16:16:04Z Re: Color top 5 in a straight table with 2 dimensions https://community.qlik.com/t5/QlikView/Color-top-5-in-a-straight-table-with-2-dimensions/m-p/1036938#M928216 <HTML><HEAD></HEAD><BODY><P>Try this expression:</P><P></P><P><STRONG>=IF(RANK(<SPAN style="color: #ff0000;">TOTAL</SPAN> sum(value)) &lt; 6, yellow())</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/118796_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Mon, 21 Mar 2016 13:28:39 GMT https://community.qlik.com/t5/QlikView/Color-top-5-in-a-straight-table-with-2-dimensions/m-p/1036938#M928216 sunny_talwar 2016-03-21T13:28:39Z Re: Color top 5 in a straight table with 2 dimensions https://community.qlik.com/t5/QlikView/Color-top-5-in-a-straight-table-with-2-dimensions/m-p/1036939#M928219 <HTML><HEAD></HEAD><BODY><P>Dear Sunny,</P><P></P><P>Yes, that is the solution.</P><P>it is a good learning point. TOTAL is important to rank, not SUM only.</P><P></P><P>Excellent!</P><P></P><P>Best regards,</P><P></P><P>Cornelis</P></BODY></HTML> Mon, 21 Mar 2016 13:53:10 GMT https://community.qlik.com/t5/QlikView/Color-top-5-in-a-straight-table-with-2-dimensions/m-p/1036939#M928219 2016-03-21T13:53:10Z