topic Re: Ranking function in charts in App Development

Ranking function in charts

Anonymous — Tue, 22 May 2018 01:25:09 GMT

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)?

Re: Ranking function in charts

sunny_talwar — Tue, 22 May 2018 01:28:51 GMT

May be this

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

Re: Ranking function in charts

sunny_talwar — Tue, 22 May 2018 01:30:31 GMT

Or this

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

Re: Ranking function in charts

Anonymous — Tue, 22 May 2018 01:32:29 GMT

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

Re: Ranking function in charts

sunny_talwar — Tue, 22 May 2018 01:35:00 GMT

You can check this in the help section

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

first one is the mode and the second one is fmt

Re: Ranking function in charts

anil529106 — Tue, 22 May 2018 02:52:12 GMT

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.

Re: Ranking function in charts

sunny_talwar — Tue, 22 May 2018 11:10:58 GMT

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