Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
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

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.