topic Re: Rank function with multiple dimensions in QlikView

Rank function with multiple dimensions

agigliotti — Fri, 25 Mar 2022 08:40:03 GMT

Hi,
I'd need to show only the first 3 rows sorted by F1 field desc.
As you can see only the first row for each date is ranked.
In the last column (if....) I'm checking if the rank is <= 3 but it does not work as requested.

The desired result should be as below:

How can I achieve it?

Attached the qvw file

Many thanks in advance for your time.

Best Regards

@rwunderlich @Digvijay_Singh @marcus_sommer @Or @Lech_Miszkiewicz @simonaubert @Chanty4u @Michael_Tarallo

Re: Rank function with multiple dimensions

Digvijay_Singh — Thu, 24 Mar 2022 22:10:34 GMT

Probably you try these parameters in your rank measure, but I don't think you can get 1,2,2,3 sequence, after equal rank you get the next rank skipped, so it would be 1,2,2,4 ranks when 2nd and 3rd items are same

Re: Rank function with multiple dimensions

Digvijay_Singh — Thu, 24 Mar 2022 22:11:36 GMT

Don't have qlikview so cannot see your expression..

Re: Rank function with multiple dimensions

agigliotti — Fri, 25 Mar 2022 08:45:31 GMT

with that expression I get exactly the same result (1,2, -, 3, -, 4,5, -, -)
I need to include also the rows (ggg, eee) with null as rank because its real rank is less or equal to 3.

Someone can help me?

Re: Rank function with multiple dimensions

Digvijay_Singh — Fri, 25 Mar 2022 14:46:25 GMT

May be this -

Re: Rank function with multiple dimensions

agigliotti — Fri, 25 Mar 2022 15:43:25 GMT

Hi @Digvijay_Singh ,
Great Job, it worked!
Many thanks for your collaboration.
Best Regards