Discussion board where members can get started with QlikView.
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?
Go to Solution.
use Dimension Limits as shown:
HTH - Andy
View solution in original post
Go to Chart property->Dimesion Limit->
thanks Andy, is it possible to have this "others" line in the same format as D1, D2 etc?
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
ye that works for me! thanks again
No problem! Have a good day!