Ranking in a line chart

Thu, 09 Feb 2012 20:49:36 GMT

I am having a problem with ranking in a line chart. One chart uses this dimension:

=aggr(
if(
rank(
Sum ({$<[As of Date] = {'12/31/2011'}>}
[ICC Counter])) <= 5
, [Insurance Company Name])
, [Insurance Company Name])

and it works fine. It displays the top 5 Companies.

The second chart is exactly the same as the first except it is looking for Companies 6-10 (I am only displaying 5 lines).

=aggr(
if(
rank(
Sum ({$<[As of Date] = {'12/31/2011'}>}
[ICC Counter])) >= 6
, [Insurance Company Name])
, [Insurance Company Name])

The result I am getting is the bottom 5 Companies.

If I change the expression to:

=aggr(
if(
rank(
Sum ({$<[As of Date] = {'12/31/2011'}>}
[ICC Counter])) = 6
, [Insurance Company Name])
, [Insurance Company Name])

I get the # 6 Company

Ranking in a line chart

pover — Thu, 09 Feb 2012 21:06:01 GMT

You should be able to get the result you're looking for if you sort by the expression Sum ({$<[As of Date] = {'12/31/2011'}>} [ICC Counter]) in the line chart in descending order or include in your if-statement the condition that the rank is less than or equal to 10 along with being greater than or equal to 6.

Karl

topic Ranking in a line chart in QlikView

Ranking in a line chart

Ranking in a line chart