topic Rank in QlikView

Rank

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

Hi,

I want to show rank top of a client, based on Sales. Can i do this with set analysis? I am trying rank(aggr(sum(Sales),[NameClient])), but when i select a client it shows 1. I need to be able to select a client and to show the rank between the rest of the clients.

Any suggestions?

Best regards,

Cosmina

Re: Rank

sunny_talwar — Thu, 22 Dec 2016 12:00:47 GMT

Can you share few rows of data and point out the expected ouput?

Re: Rank

lironbaram — Thu, 22 Dec 2016 12:06:05 GMT

you can use set analysis in your rank

if you display a table with customer rank

this should do the trick

max(aggr(rank(sum({<NameClient=>}Sales)),NameClient))

Re: Rank

vinieme12 — Thu, 22 Dec 2016 12:33:49 GMT

TRY

AGGR(NODISTINCT rank(SUM({1}Sales),1,1),[NameClient])

Re: Rank

Thu, 22 Dec 2016 12:46:50 GMT

Try this

rank(sum({<NameClient=>}Sales))

Re: Rank

Anonymous — Thu, 22 Dec 2016 17:08:18 GMT

Thank you all,

I tested

max(aggr(rank(sum({<NameClient=>}Sales)),NameClient)) and works.

Best regards,

Cosmina