topic Re: bar chart in QlikView

bar chart

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: bar chart

ecolomer — Thu, 13 Oct 2016 17:40:26 GMT

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

Re: bar chart

MK9885 — Thu, 13 Oct 2016 17:44:22 GMT

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.

Re: bar chart

Anonymous — Thu, 13 Oct 2016 17:45:35 GMT

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

Re: bar chart

awhitfield — Fri, 14 Oct 2016 09:25:53 GMT

Hi Zaira,

Just untick this:

HTH Andy

Re: bar chart

Anil_Babu_Samineni — Fri, 14 Oct 2016 09:38:29 GMT

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

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

Re: bar chart

beck_bakytbek — Fri, 14 Oct 2016 13:30:30 GMT

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

Re: bar chart

kkkumar82 — Fri, 14 Oct 2016 15:27:03 GMT

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