Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

barnaby
New Contributor II

Rank function showing all 1s

G'day All,

This is a similar question to this, https://community.qlikview.com/thread/51784, which was never answered.

I have some client churn information that I am attempting to place in a straight table chart. I need to sort them in order of contribution and then highlight the top three drivers (by shading all the others). I am successfully using the Rank function to achieve the shading.

2016-02-29 Test Rank and Shade 1.png

This is looking good, but then I need to add an extra description column for the key insights and now the Rank function returns all 1s and the table sort stops working.

2016-02-29 Test Rank and Shade 2.png

Can someone please explain how to fix this problem? I suspect I need to use the Aggr function to cater for the extra dimension, but I have not been able to find any information that explains this issue.

Thanks in advance.

Cheers,

Barnaby.

Tags (2)
1 Solution

Accepted Solutions

Re: Rank function showing all 1s

May be this:

Rank( TOTAL avg( Contribution))

Capture.PNG

View solution in original post

2 Replies

Re: Rank function showing all 1s

May be this:

Rank( TOTAL avg( Contribution))

Capture.PNG

View solution in original post

Highlighted
barnaby
New Contributor II

Re: Rank function showing all 1s

Thanks Sunny - that's it. After seeing this, I re-read the help on the Rank function and I now understand it. I found it completely cryptic beforehand.

2016-03-01 Test Rank and Shade 3.png

I now have what I need.

Cheers,

Barnaby.