topic Re: Unable to Calculate Top records in QlikView

Unable to Calculate Top records

Karim_Khan — Fri, 14 Aug 2015 14:57:45 GMT

Hi Team,

I am unable to calculate Top 5 Customers.I have applied the following expression in

=AGGR(IF(Rank(sum([Net Bookings]), 4)<=5, [End Customer Global Ultimate Name]),[End Customer Global Ultimate Name])

and I have applied

=sum([Net Bookings])

Its getting calcuated but By default Month is getting Pick in Second expression.

=sum([Net Bookings])

If I want to chnage the same by Applying month its not capturing the Month field in Expression pls suggest

Regards,

K K

swuehl — Fri, 14 Aug 2015 16:38:45 GMT

Sorry, I don't understand your description. Could you post a small sample QVW?

Anonymous — Sun, 16 Aug 2015 18:30:36 GMT

Hi,

you can use [End Customer Global Ultimate Name] as dimension and sum([Net Bookings]) as the expression.

Then, in Dimension limit tab check "Restrict which values are displayed......" and the option "Show only" largest 5 values.