Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Ranking Including All The Dimensions and Expression

Greetings All,

Could you please tell me how to rank one calculated field where other calculated fields are there.

I know this explanation is might be Fussy.

Please find attached of the qvw file. I hope by seeing this model you all will able to figure out my problem.

Waiting for the response.

Thanks in Advance.

Pihu.

Tags (1)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Ranking Including All The Dimensions and Expression

Hi,

Use TOTAL in the Rank().

=rank(TOTAL sum({< Customer = {"=rank(sum([SalesValue]), Customer) <=$(vRankNo)"} >} [SalesValue])  )

Hope this helps you.

Regards,

Jagan.

2 Replies
MVP & Luminary
MVP & Luminary

Ranking Including All The Dimensions and Expression

Hi,

Use TOTAL in the Rank().

=rank(TOTAL sum({< Customer = {"=rank(sum([SalesValue]), Customer) <=$(vRankNo)"} >} [SalesValue])  )

Hope this helps you.

Regards,

Jagan.

Not applicable

Re: Ranking Including All The Dimensions and Expression

Thanks Jagan..!!

I found where I was wrong.

NB: If we have more than one expression and we want to use rank then we should rank only one specific field.

It also works for me.

(sum({<customer_code= {"=rank(sum([logistics_fee]), [customer_code]) <=$(vRankNo)"} >} [logistics_fee])  )