topic Re: Ranking max top 5 in QlikView

Ranking max top 5

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

Hi,

I need some help selecting the top 5 costs, but I'm having some problem because it's returning negative values also, but I want only values great then zero to return..

The result shoud be as below:

Could you please help me?

Re: Ranking max top 5

swuehl — Sun, 19 Jun 2016 10:27:32 GMT

Maybe use one of the approaches shown in attached sample

Re: Ranking max top 5

antoniotiman — Sun, 19 Jun 2016 10:32:11 GMT

See attachment

Re: Ranking max top 5

silvia_assuncao — Mon, 20 Jun 2016 14:45:54 GMT

Hi! both solutions worked.

Now I'm tryin to create the same ranking using a variable, but it's not returning any vaue. could you please help me with this last one?

Sum({<[Unique Account ID] = {"=Rank ,0)<=5"}>} ($(vTotal_Cost)) )

Re: Ranking max top 5

swuehl — Mon, 20 Jun 2016 15:37:17 GMT

Sorry, I don't understand what you are trying to achieve.

The expression looked like e.g.

=Sum({<[Unique Account ID] = {"=Rank(RangeSum(Sum({<[Adjust Type]={C},[Registry ID] = {70},[Adjust Signal]={-}>}[Adjust Amount]*(-1)),

Sum({<[Adjust Type]={C}, [Registry ID] = {70}, [Adjust Signal]={+}>} [Adjust Amount])),0)<=5"},[Adjust Signal]={'+'}>} [Adjust Amount])

What's the definition of your variable? If you want to replace the field with a variable, you would need to do this in every place it show up.

Re: Ranking max top 5

silvia_assuncao — Mon, 20 Jun 2016 17:44:27 GMT

Hi! I've created a variable for the total cost, and then I did create the ranking as dimension. but I see that not all values are the 5 greatest.

below the values which should be the top five:

I'm also attaching here the qvw

Re: Ranking max top 5

swuehl — Mon, 20 Jun 2016 19:40:19 GMT

I think it's just an issue with how you use your variable, see attached.

Re: Ranking max top 5

Mon, 20 Jun 2016 20:01:48 GMT

see the attachment. I built another version with the correct top 5

Is it ok for your necessity?

Re: Ranking max top 5

silvia_assuncao — Mon, 20 Jun 2016 20:13:18 GMT

Hi Swuel, I cannot find your new attachement here... could you please uplad it here again? thanks

Re: Ranking max top 5

swuehl — Mon, 20 Jun 2016 20:23:32 GMT

Please find attached.

Re: Ranking max top 5

susovan — Tue, 21 Jun 2016 05:50:54 GMT

Hi Silvia,

PFA

Re: Ranking max top 5

silvia_assuncao — Tue, 21 Jun 2016 14:57:59 GMT

Yes!!! it worked!!! thanks a lot!!!

best regards,

Re: Ranking max top 5

silvia_assuncao — Tue, 21 Jun 2016 14:59:11 GMT

Thanks for your help Rodrigo