topic 1st, 2nd, 3rd, 4th and 5th Highest Values in QlikView

1st, 2nd, 3rd, 4th and 5th Highest Values

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Im trying to create a chart with 1 to 5 highest ranking. Im getting some ranking but where the values are zeros or same then its not showing the ranking as you can see below:

The logic I am trying to build is:

If (B1 = 'B1' , rank 1 to 5) based on COLUMN (PBF1 , PBF2 , PBF3 , PBF4 , PBF5)

Can you please advise me how to resolve this?

I have attached the qv sample file.

Thanks Regards,

Farrukh

Re: 1st, 2nd, 3rd, 4th and 5th Highest Values

sunny_talwar — Tue, 30 Oct 2018 19:07:25 GMT

If you look at the example where there is no value for CBF1.. you will see that none of the 5 variables have value 3

In fact, the last variable ($(PBF_1_5_1L)) is not even available in the application and the second last variable ($(PBF_1_5_2L)) is always 0.

Re: 1st, 2nd, 3rd, 4th and 5th Highest Values

sunny_talwar — Tue, 30 Oct 2018 19:16:17 GMT

Here fixed the two variables and it seems to fix the issue

Re: 1st, 2nd, 3rd, 4th and 5th Highest Values

Anonymous — Tue, 30 Oct 2018 19:27:33 GMT

Hi sunny

CBF1 has the formula which is calculating the rank. As u can see some of the cells have 1H 2H etc

PBF1 TO 5 have the values and im using the variables PBF_1_5_1H to 1L ... to rank based on PBF1 , 2 , 3 , 4 , 5

Please let me know if above description not explained clearly

Kind regards

FARRUKH

Re: 1st, 2nd, 3rd, 4th and 5th Highest Values

sunny_talwar — Tue, 30 Oct 2018 19:28:21 GMT

Did you check my second response?

Re: 1st, 2nd, 3rd, 4th and 5th Highest Values

Anonymous — Wed, 31 Oct 2018 09:46:13 GMT

Thanks a mil Sunny!