topic Re: set expression for ranking in Charts (top5 & bottom5) in App Development

set expression for ranking in Charts (top5 & bottom5)

khanashique — Mon, 10 Sep 2018 11:01:32 GMT

Hi Experts,

I need to set expression in Charts and its ranking need to be shown as top5 and bottom5 together...

Thanks,

MAK.

Re: set expression for ranking in Charts (top5 & bottom5)

avinashelite — Mon, 10 Sep 2018 11:42:54 GMT

Try like this

=aggr(if(rank(sum(value))<=5 or rank(-sum(value))<=5,DIMENSION),DIMENSION)

Re: set expression for ranking in Charts (top5 & bottom5)

khanashique — Mon, 10 Sep 2018 11:50:03 GMT

Hi Avinash,

I have tried the above expression but it does not work...

Thanks,

MAK.

Re: set expression for ranking in Charts (top5 & bottom5)

avinashelite — Mon, 10 Sep 2018 11:53:02 GMT

its working for me ..could share the expression how your trying ?

Re: set expression for ranking in Charts (top5 & bottom5)

khanashique — Mon, 10 Sep 2018 11:55:39 GMT

aggr(if(rank(sum([Sales Target]))<=5 or rank(-sum([Sales Target]))<=5,Customer),Customer)

Re: set expression for ranking in Charts (top5 & bottom5)

avinashelite — Mon, 10 Sep 2018 12:08:14 GMT

Your trying this in the expression or dimension?

paste the above expression in the dimension and use sum([Sales Target]) in the expression that should work

Re: set expression for ranking in Charts (top5 & bottom5)

khanashique — Mon, 10 Sep 2018 12:16:29 GMT

Under Dimension i have used field 'Customer' and the above expression i have used in Expression Editor (Dimension)

Re: set expression for ranking in Charts (top5 & bottom5)

avinashelite — Mon, 10 Sep 2018 12:26:53 GMT

na use create a calculated dimension

Dimesnion :

aggr(if(rank(sum([Sales Target]))<=5 or rank(-sum([Sales Target]))<=5,Customer),Customer)

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Dimensions/create-calculated-dimension.htm

Expression

sum([Sales Target])

Re: set expression for ranking in Charts (top5 & bottom5)

khanashique — Mon, 10 Sep 2018 12:33:29 GMT

After applying the above expression in master item as dimension now it gives only top 5 customer, bottom 5 is missing...

Re: set expression for ranking in Charts (top5 & bottom5)

khanashique — Tue, 11 Sep 2018 04:32:22 GMT

Hi Avinash,

Any Luck.? i have tried but i got top 5 customers only....need to get bottom 5 too.

thanks,

MAK.

Re: set expression for ranking in Charts (top5 & bottom5)

avinashelite — Tue, 11 Sep 2018 09:23:33 GMT

Currently I don't have the access for Qliksense , I have tested the expression in Qlikview its working fine ....