Ranking function in charts

[Anonymous]

What I have for now is this the rank sharing the same group '1-5', '6-14', '15-19'. How should I edit the formula, so that i only get 1 instead of 1-5, 6 instead of 6-14, 15 for (15-19), 20 for (20-22)?

[sunny_talwar]

May be this

Aggr(Rank(-Sum([Total Complaint Received]), 1), Factory)

[sunny_talwar · Accepted solution]

Or this

Aggr(Rank(-Sum([Total Complaint Received]), 1, 1), Factory)

[Anonymous]

This works. Can I know the ,1,1 represent what?

[sunny_talwar]

You can check this in the help section

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/RankingFu...‌

first one is the mode and the second one is fmt

[anil529106]

Hi Sunny, i have a related question...

Result now:

Concatenation of rank with dim based on measure.

1) Product1(250)

2-3) Product 2 (150)

2-3) product3 (150)

4) Product4 (100)

Result needed:

1) Product(250)

2) Product(150)

3) Product(150)

4) Product(100)

I tried to concatenate rowno() with rest but rowno() don't work in dimension.

[sunny_talwar]

Can you share the file? I would not know without seeing what you have