topic Getting Top 4 Sum instead of Top 5 Sum ...? in QlikView

Getting Top 4 Sum instead of Top 5 Sum ...?

Fri, 31 Jul 2015 10:32:16 GMT

Hi Frnz,

I want Top 5 Sum fot AMID and AMID_ID. I am getting for AMID_ID but not for AMID.

Something wrong, Please help me to find solution.

Please find the attached QVW.

Re: Getting Top 4 Sum instead of Top 5 Sum ...?

swuehl — Fri, 31 Jul 2015 15:07:32 GMT

That's because your advanced aggregation is not aware of your AMID filtering in the chart dimension, thus considering 'TTTT' when ranking, but filtering it when matching advanced aggregation dimensions with outer chart dimensions.

You would need the dimension filter also in the inner aggregation (since aggr() function does not allow a calculated dimension):

=sum(aggr(if(rank(sum( {<AMID -= {"TTT*"}>} Sale))<=5,sum(Sale)),YEAR,AMID))

Re: Getting Top 4 Sum instead of Top 5 Sum ...?

qlikviewwizard — Fri, 31 Jul 2015 15:39:56 GMT

Nice one.