topic Re: Rank Sum Issue in QlikView

Rank Sum Issue

dineshm030 — Thu, 05 Apr 2018 10:52:44 GMT

Hi All,

The rank is not coming for remaining region while selecting Punjab region. I want to show the rank based on region brand groups.

Expression:

Aggr(Rank(Sum({<[Brand groups]>}NVALUE),1,1),[Brand groups])

thevingo — Thu, 05 Apr 2018 11:02:44 GMT

try

=Aggr(Rank(TOTAL Sum({<[Brand groups]=, Region=>} NVALUE),1,1),[Brand groups])

dineshm030 — Thu, 05 Apr 2018 11:07:31 GMT

its not working... i want to show the rank all region.

elmardi0107 — Thu, 05 Apr 2018 11:13:12 GMT

Hi Dinesh,

You have just to reverse the formula as below:

Rank(Aggr(sum),city,Produit))

Rank before Aggr.

Hope that's help.

sunny_talwar — Thu, 05 Apr 2018 11:23:07 GMT

May be this

Only({<Region, [Brand groups]>}Aggr(Rank(Sum({<Region, [Brand groups]>}NVALUE),1,1),[Brand groups]))

olivierrobin — Thu, 05 Apr 2018 11:23:49 GMT

hello,

and with TOTAL <region> ?

elmardi0107 — Thu, 05 Apr 2018 20:02:20 GMT

Hi Dinesh,

You have just to reverse the formula as below:

Rank(Aggr(sum),city,Produit))

Rank before Aggr.

Hope that's help.