topic Ranking Including All The Dimensions and Expression in QlikView

Ranking Including All The Dimensions and Expression

Thu, 01 Mar 2012 06:17:30 GMT

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.

jagan — Thu, 01 Mar 2012 07:26:39 GMT

Hi,

Use TOTAL in the Rank().

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

Hope this helps you.

Regards,

Jagan.

Thu, 01 Mar 2012 08:08:07 GMT

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]) )