topic Re: RANK in QlikView https://community.qlik.com/t5/QlikView/RANK/m-p/635473#M677089 <HTML><HEAD></HEAD><BODY><P>You have RGB(255,255,255) in Text Color of Rank Column.</P></BODY></HTML> Mon, 02 Jun 2014 08:26:07 GMT antoniotiman 2014-06-02T08:26:07Z RANK https://community.qlik.com/t5/QlikView/RANK/m-p/635472#M677088 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have a problem getting 'RANK' to work for me.</P><P></P><P>My client produces certain items&nbsp; and these items all have minimum stock quantities.&nbsp; He wants a dashboard with 10 or so gauges indicating items which has fallen below these minimum quantities. There are never more than 5 or 6 items which are below minimum qty's. on any given day.</P><P></P><P>I'm trying to achieve this -</P><P></P><P>Item&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MinQty&nbsp;&nbsp;&nbsp;&nbsp; InStock&nbsp;&nbsp;&nbsp;&nbsp; Critical&nbsp;&nbsp;&nbsp;&nbsp; Rank</P><P>D074&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>D075&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P>B65&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 </P><P>B45&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>G34&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P></P><P>So the gauges will have a conditional show based on whether Critical &gt; 0 and the leftmost gauge on the screen will display the item with the highest rank (B45), the gauge to the right of that gauge will be the 2nd highest rank (D075) and so on.</P><P></P><P>I'm including a sample of the QV doc. How can I get Rank to work, please.</P><P></P><P>Regards</P></BODY></HTML> Mon, 02 Jun 2014 08:21:08 GMT https://community.qlik.com/t5/QlikView/RANK/m-p/635472#M677088 2014-06-02T08:21:08Z Re: RANK https://community.qlik.com/t5/QlikView/RANK/m-p/635473#M677089 <HTML><HEAD></HEAD><BODY><P>You have RGB(255,255,255) in Text Color of Rank Column.</P></BODY></HTML> Mon, 02 Jun 2014 08:26:07 GMT https://community.qlik.com/t5/QlikView/RANK/m-p/635473#M677089 antoniotiman 2014-06-02T08:26:07Z Re: RANK https://community.qlik.com/t5/QlikView/RANK/m-p/635474#M677090 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Fix the text colour as above, and use the following expression:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; =Rank(Aggr(Sum(CriticalTotal), PartNo), 4, 1)</P><P></P><P>HTH</P><P>Jonathan</P></BODY></HTML> Mon, 02 Jun 2014 08:42:13 GMT https://community.qlik.com/t5/QlikView/RANK/m-p/635474#M677090 jonathandienst 2014-06-02T08:42:13Z