Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

show rank number within sum() conditions

Hi guys,

I want to show the ranknummer of severel sum() conditions like:

ID1Amount
111
222
233
344

IDrank(sum(Amount)) ???sum(Amount)
1311
2155
3244

What is the righr expression for this dimension ?

thx.

Tags (3)
1 Solution

Accepted Solutions
awhitfield
Esteemed Contributor

Re: show rank number within sum() conditions

HI Tobias,

I have attached a simple example with the ranking expression =Rank(sum(Amount))

HTH

Andy

5 Replies
santhoo_san
Contributor II

Re: show rank number within sum() conditions

=Rank(sum(Amount))

help4qv123
Contributor

Re: show rank number within sum() conditions

If u are using 'rank' it is showing u the position of your Dimension in respect to its value....

so if u dont need the sum value, just want to see the position then use rank.

awhitfield
Esteemed Contributor

Re: show rank number within sum() conditions

HI Tobias,

I have attached a simple example with the ranking expression =Rank(sum(Amount))

HTH

Andy

Digvijay_Singh
Honored Contributor III

Re: show rank number within sum() conditions

Please check the attached qvw reflecting the same-

Not applicable

Re: show rank number within sum() conditions

thanks guys, I was trying with aggr() and rank() , but only rank(sum(x)) is enough. thanks yall

Community Browser