topic Rank function Null Issue in QlikView https://community.qlik.com/t5/QlikView/Rank-function-Null-Issue/m-p/1227804#M391648 <HTML><HEAD></HEAD><BODY><P>HI Guru's,</P><P></P><P>I am using Rank function to get Top 10 customers in pivot table , but I am getting 9 customers and 10th customer it is showing up as null.In my customer column have above 20 customers,below is the calculated dimension I am using .</P><P>Calculated Dimension:</P><P>=if(aggr(rank(Count(customer)),Name)&lt;=$(vTop),Name)</P><P></P><P>Expression:</P><P></P><P>Count(customer)</P><P></P><P></P><P>vTop=10</P><P></P><P></P><P>Result:</P><P>Name&nbsp;&nbsp;&nbsp; Count</P><P>A&nbsp;&nbsp;&nbsp; 13</P><P>B&nbsp;&nbsp;&nbsp; 12</P><P>C&nbsp;&nbsp;&nbsp; 11</P><P>D&nbsp;&nbsp;&nbsp; 11</P><P>F&nbsp;&nbsp;&nbsp; 9</P><P>G&nbsp;&nbsp;&nbsp; 8</P><P>H&nbsp;&nbsp;&nbsp; 7</P><P>I&nbsp;&nbsp;&nbsp; 6</P><P>J&nbsp;&nbsp;&nbsp; 5</P><P>-&nbsp;&nbsp;&nbsp; 36</P><P></P><P></P><P>Thanks,</P><P>Sateesh</P></BODY></HTML> Fri, 25 Nov 2016 09:52:29 GMT sat_tok52 2016-11-25T09:52:29Z Rank function Null Issue https://community.qlik.com/t5/QlikView/Rank-function-Null-Issue/m-p/1227804#M391648 <HTML><HEAD></HEAD><BODY><P>HI Guru's,</P><P></P><P>I am using Rank function to get Top 10 customers in pivot table , but I am getting 9 customers and 10th customer it is showing up as null.In my customer column have above 20 customers,below is the calculated dimension I am using .</P><P>Calculated Dimension:</P><P>=if(aggr(rank(Count(customer)),Name)&lt;=$(vTop),Name)</P><P></P><P>Expression:</P><P></P><P>Count(customer)</P><P></P><P></P><P>vTop=10</P><P></P><P></P><P>Result:</P><P>Name&nbsp;&nbsp;&nbsp; Count</P><P>A&nbsp;&nbsp;&nbsp; 13</P><P>B&nbsp;&nbsp;&nbsp; 12</P><P>C&nbsp;&nbsp;&nbsp; 11</P><P>D&nbsp;&nbsp;&nbsp; 11</P><P>F&nbsp;&nbsp;&nbsp; 9</P><P>G&nbsp;&nbsp;&nbsp; 8</P><P>H&nbsp;&nbsp;&nbsp; 7</P><P>I&nbsp;&nbsp;&nbsp; 6</P><P>J&nbsp;&nbsp;&nbsp; 5</P><P>-&nbsp;&nbsp;&nbsp; 36</P><P></P><P></P><P>Thanks,</P><P>Sateesh</P></BODY></HTML> Fri, 25 Nov 2016 09:52:29 GMT https://community.qlik.com/t5/QlikView/Rank-function-Null-Issue/m-p/1227804#M391648 sat_tok52 2016-11-25T09:52:29Z Re: Rank function Null Issue https://community.qlik.com/t5/QlikView/Rank-function-Null-Issue/m-p/1227805#M391649 <HTML><HEAD></HEAD><BODY><P>Could it be that there are <STRONG>multiple</STRONG> names with the same 10th value (36)?</P></BODY></HTML> Fri, 25 Nov 2016 09:57:48 GMT https://community.qlik.com/t5/QlikView/Rank-function-Null-Issue/m-p/1227805#M391649 tresB 2016-11-25T09:57:48Z