topic Re: Top 10 Rank in QlikView

Top 10 Rank

jamelmessaoud — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

I have an expression

=SUM({<CalDateMonth ={$(vCurrentMonth)}>} Revenue)

Is there any way I can add the Rank function to this and show the top 10 ?

Thanks

olivierrobin — Mon, 14 May 2018 13:36:38 GMT

hello

why don't you use dimensional limits tab in your graph ?

jamelmessaoud — Mon, 14 May 2018 13:40:07 GMT

I would like to add a couple of other measures also and not just the revenue if that makes sense?

olivierrobin — Mon, 14 May 2018 13:42:15 GMT

you can add all measures you need and limit the display by using one or more of this measure

in your case, you could all a measure giving the rank and limit the display to the n first values

jamelmessaoud — Mon, 14 May 2018 13:45:01 GMT

Figured this out now. Should really use the search function before posting shouldn't I.

I found this thread

Anil_Babu_Samineni — Mon, 14 May 2018 13:45:34 GMT

May be use this?

SUM({<FieldName = {"=Rank(SUM({<CalDateMonth ={$(vCurrentMonth)}>} Revenue))<=10"}>}Sales)

olivierrobin — Mon, 14 May 2018 13:50:19 GMT

now you have a lot of solutions to your problem. Be careful that the end of the post seems to be QlikSense.

jamelmessaoud — Mon, 14 May 2018 13:54:39 GMT

This is the exact expression which i used. Thanks guys