topic Re: Issue with ranking through aggr function in QlikView

Issue with ranking through aggr function

Anonymous — Wed, 08 Apr 2015 10:09:12 GMT

Hello,

I am using an aggr function to rank the top 5 values in a field however the function is only producing the top 5 rather and putting them an order. Any suggestions as to how to tweak the expression so that it gives them in order by largest value?

Thanks

=Concat(DISTINCT IF(aggr(rank(sum([field 1])),[field2])<=5,[field2] &CHR(13)))

Re: Issue with ranking through aggr function

buzzy996 — Wed, 08 Apr 2015 10:29:22 GMT

try this,

1.properties of ur chart---sort tab---Sort by--check the CHECK BOX Y-value with descending as order from drop down, it'helps.

Re: Issue with ranking through aggr function

hic — Wed, 08 Apr 2015 10:31:06 GMT

Try using the sort weight in the Concat() function:

concat( expression , delimiter , sort_weight )

HIC

Re: Issue with ranking through aggr function

sunny_talwar — Wed, 08 Apr 2015 10:31:21 GMT

I think Shiva he is talking about the sort within the concatenate, am I right Brian?