topic Re: Rank problem in QlikView

Rank problem

Tue, 18 Nov 2014 09:55:45 GMT

Hi all,

I have a qvw app which contains only 1 table:

I want to create a straight table:

Dimension: area

Expression:

1. mkt size=sum({<prd=>}sales)

2. prd sales=sum(sales)

3. rank = i do not know

when selecting 1 prd (say 'p1'), the 'rank ' expression will shoe the ranking of 'p1 'in each area.

if i select 'p2' , the right appearence of this straight should be:

how this 'rank' expression should be ? Thank you all in advance!

Attachment is my app.

Anonymous — Tue, 18 Nov 2014 10:13:26 GMT

Try this this is working

=Rank(sum(sales))

Regards

Harsha

Tue, 18 Nov 2014 10:15:03 GMT

try this

aggr(rank(sum(sales),prd,area))

kristoferahlin — Tue, 18 Nov 2014 10:17:45 GMT

Hi,

Please see attached example.

Regards,

Kristofer

Wed, 19 Nov 2014 01:58:15 GMT

Thank you. You got the right rankings. But i still don't know why the ' {<prd=>}' should be added in the expression.

Anyway i will use your expression. Thanks again.