bar chart

[#1]

Hi guys

I'm new in Qlikview and I've got a bar chart and am trying to do a top 10.The best companies with best sales. In dimesion limits' tab set an exact amount, but i have a problem with "others". I've got my 10 best companies and others.

is there any option to customizing it?

Thank you.    

[ecolomer]

Yes you can no select option for Others, and only you see the 10 best

[MK9885]

Properties>Dimension Limits>Check restrict box to show only top 10 values.

If you want others also to show on chart then check the others box in Dimension limits.

[Anonymous]

You can uncheck the Show Others in Dimension Limits and select Largest 10 Values in Limits section.

[awhitfield]

Hi Zaira,

Just untick this:

HTH Andy

[Anil_Babu_Samineni]

If Your Expression is Sum(Sales) Then you can try this

=if(aggr(rank(sum(Sales)),Dimension)<=100,Dimension)

[beck_bakytbek]

Hi Zaira,

as Anil said. you try his: example: =if(aggr(rank(sum(Sales)),Dimension)<=100,Dimension)

or you can try this: =if(aggr(rank(sum(Sales)),Companies)<=10,Dimension, Null())

and dont Forget to supress When Value is Null:

i hope that helps

beck

[kkkumar82]

Please select a correct or helpful answer to close this thread, so that it may be helpful for others