Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

knightwriter
Contributor III

Show 5 and sum the rest as "Others"

    Hi All,

How do I show the top 5 (by value) and have the 6th line as "Other" with a sum of the rest of the table?

Many thanks.

Tags (1)
1 Solution

Accepted Solutions
Partner
Partner

Re: Show 5 and sum the rest as "Others"

Hi Stephen,

use Dimension Limits as shown:

HTH - Andy

View solution in original post

6 Replies

Re: Show 5 and sum the rest as "Others"

Hi,

Go to Chart property->Dimesion Limit->

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Partner
Partner

Re: Show 5 and sum the rest as "Others"

Hi Stephen,

use Dimension Limits as shown:

HTH - Andy

View solution in original post

knightwriter
Contributor III

Re: Show 5 and sum the rest as "Others"

thanks Andy, is it possible to have this "others" line in the same format as D1, D2 etc?

Partner
Partner

Re: Show 5 and sum the rest as "Others"

Almost, right click the cell and use 'Custom Cell Format' (use - View Design Grid if you don't have the option displayed) and you can get it like this:

i.e no bold or background colour

Andy

knightwriter
Contributor III

Re: Show 5 and sum the rest as "Others"

ye that works for me! thanks again

Partner
Partner

Re: Show 5 and sum the rest as "Others"

No problem! Have a good day!

Andy