topic Getting dimension percentile in QlikView https://community.qlik.com/t5/QlikView/Getting-dimension-percentile/m-p/1298738#M616152 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I would like to have your support in two challenges I am facing in my application.</P><P></P><P>#1</P><P></P><P>I have a table with my company´s suppliers, which is sorted by theirs deliverable grades (from the highest to the lowest). I would like to add in this table a column with the rownumber and also in which percentile this supplier is among all of them (the table is below: the suppliers are in the first column - dimension - and they are sorted by their grades - the last column ("NOTA GERAL").</P><P></P><P><IMG alt="Table_Suppliers.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167039_Table_Suppliers.JPG" style="height: 170px; width: 620px;" /></P><P></P><P>#2</P><P></P><P>Using the application´s filters, I would like to keep at least the supplier percentile even if its also filteres (e.g. I would like to see that "PRIMO FACTORY" is in position number two, even if the user filter only him (keeping all the others filters on))</P><P></P><P>If I was not clear enough, please tell me!</P><P></P><P>Regards and thank you in advance!</P></BODY></HTML> Thu, 15 Jun 2017 22:12:01 GMT Anonymous 2017-06-15T22:12:01Z Getting dimension percentile https://community.qlik.com/t5/QlikView/Getting-dimension-percentile/m-p/1298738#M616152 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I would like to have your support in two challenges I am facing in my application.</P><P></P><P>#1</P><P></P><P>I have a table with my company´s suppliers, which is sorted by theirs deliverable grades (from the highest to the lowest). I would like to add in this table a column with the rownumber and also in which percentile this supplier is among all of them (the table is below: the suppliers are in the first column - dimension - and they are sorted by their grades - the last column ("NOTA GERAL").</P><P></P><P><IMG alt="Table_Suppliers.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167039_Table_Suppliers.JPG" style="height: 170px; width: 620px;" /></P><P></P><P>#2</P><P></P><P>Using the application´s filters, I would like to keep at least the supplier percentile even if its also filteres (e.g. I would like to see that "PRIMO FACTORY" is in position number two, even if the user filter only him (keeping all the others filters on))</P><P></P><P>If I was not clear enough, please tell me!</P><P></P><P>Regards and thank you in advance!</P></BODY></HTML> Thu, 15 Jun 2017 22:12:01 GMT https://community.qlik.com/t5/QlikView/Getting-dimension-percentile/m-p/1298738#M616152 Anonymous 2017-06-15T22:12:01Z Re: Getting dimension percentile https://community.qlik.com/t5/QlikView/Getting-dimension-percentile/m-p/1298739#M616153 <HTML><HEAD></HEAD><BODY><P>3 new columns:</P><P></P><P>Rank:</P><P>Only(Aggr(Rank(Sum({1} GRADE)) * Avg(1), SUPPLIER))</P><P></P><P>#SUPPLIERS:</P><P>=count({1} total DISTINCT SUPPLIER)</P><P></P><P>Percentile:</P><P>=(<SPAN style="font-size: 13.3333px;">#SUPPLIERS</SPAN>-<SPAN style="font-size: 13.3333px;">Rank</SPAN>)/(<SPAN style="font-size: 13.3333px;">#SUPPLIERS</SPAN>-1)</P></BODY></HTML> Fri, 16 Jun 2017 15:26:56 GMT https://community.qlik.com/t5/QlikView/Getting-dimension-percentile/m-p/1298739#M616153 igorgois_ 2017-06-16T15:26:56Z