Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
dmohanty
Partner - Specialist
Partner - Specialist

Rank Help!

H All,

I have a chart like this below. I want to show the Bottom 5 from this. How can this be done using Rank Function?

Can the same be done using Dimensional Limits?

Please help!

IDValue
30502113A4.55%
REUSE-11-2MQ5.56%
739105.56%
732115.88%
1053536.25%
30502111SA6.67%
01690-3007.14%
30503-014A7.69%
30506-10A7.69%
799207.69%
DS45-118.33%
PORT-18.33%
524008.33%
580108.33%
4800-609.09%
30506-19A9.09%
ARDEN-S2BK9.09%
30506-13LA10.00%
REUSE-09-1HP10.00%
2 Replies
maxgro
MVP
MVP

see attachment

dmohanty
Partner - Specialist
Partner - Specialist
Author

Hi Massimo,

Many thanks for the help.

Infact wanted to tell that this Value field is calculated from an expression like below:

=Count(DISTINCT{<[PO Line On-Time] = {'Y'},[Supplier Material Number] = {"=Rank(Count([PO Doc - Item]))<=5"}>}[PO Doc - Item])

/

count(DISTINCT{<[Supplier Material Number] = {"=Rank(Count([PO Doc - Item]))<=5"}>}[PO Doc - Item])

So, when I am applying Rank function here, it doesn't takes the Smallest 5, rather it takes some Random 5 in between.

Any issues in my expression?

If I store this expression in a variable and try to Rank it....Will that help?