Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Getting dimension percentile

Dear All,

I would like to have your support in two challenges I am facing in my application.

#1

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").

Table_Suppliers.JPG

#2

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))

If I was not clear enough, please tell me!

Regards and thank you in advance!

1 Reply
igorgois_
Partner - Creator
Partner - Creator

3 new columns:

Rank:

Only(Aggr(Rank(Sum({1} GRADE)) * Avg(1), SUPPLIER))

#SUPPLIERS:

=count({1} total DISTINCT SUPPLIER)

Percentile:

=(#SUPPLIERS-Rank)/(#SUPPLIERS-1)