topic Re: Rank Help! in QlikView

Rank Help!

dmohanty — Sun, 08 Mar 2015 16:17:44 GMT

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!

maxgro — Sun, 08 Mar 2015 17:05:08 GMT

see attachment

dmohanty — Sun, 08 Mar 2015 17:14:20 GMT

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?