topic Re: Control Bar width in Bar Chart in QlikView

Control Bar width in Bar Chart

Anonymous — Wed, 09 Mar 2016 18:23:13 GMT

Hi Experts,

Is there any way to have consistent bar width in bar chart.

Scenario is when the data is shown for all months the bar width is fine but when a particular month is selected the bar width expands.

But my need is to have the consistent bar width irrespective of the number of months selected.

Any help regarding this issue is appreciated.

PS : I have tried using the "Cluster Distance" option in bar settings in presentation tab but no luck.

Regards,

Re: Control Bar width in Bar Chart

rwunderlich — Wed, 09 Mar 2016 18:33:43 GMT

QV always readjusts the size of bars to fill the plot area. The only way I know of to maintain the width is to plot all bars but color the non-selected bars with a transparent color argb(0,0,0,0)

Attached is an example. It still has the problem of showing labels for extra months, but I'm sure there is a workaround for that.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Control Bar width in Bar Chart

Gysbert_Wassenaar — Wed, 09 Mar 2016 18:35:33 GMT

No, that's not possible afaik without keeping zero bars for the excluded months. The bars will adjust to the available plot space. Less dimension values means more space for each bar, so wider bars.

Re: Control Bar width in Bar Chart

Anonymous — Wed, 09 Mar 2016 18:38:16 GMT

Hi Rob,

Thanks for your reply.

But in this scenario I cannot plot all bars because if only one month is selected then by default there will be a single bar.

Regards,

Re: Control Bar width in Bar Chart

Anonymous — Wed, 09 Mar 2016 18:40:31 GMT

Hi Gysbert,

Thanks for your reply.

I concur you on the point.

Still I am looking for any possible workaround.

Regards,

Re: Control Bar width in Bar Chart

rubenmarin — Wed, 09 Mar 2016 18:55:54 GMT

Hi, as said above, to keep the bar widht you must keep also the dimension values, if you don't mind to show month names out of selections you can check the 'Show all values' in the dimension tab and uncheck the 'Supress zero values' in Presentation tab.

In example, with no selections:

Selecting '4':

Re: Control Bar width in Bar Chart

Anonymous — Wed, 09 Mar 2016 19:05:15 GMT

Hi Ruben,

Thanks for your reply.

The solution you gave works when Month is the only dimension.

But in my case now I am facing other challenge.

I have two dimensions Month and Year.

Any suggestion on this.

Regards,

Re: Control Bar width in Bar Chart

veidlburkhard — Wed, 09 Mar 2016 19:22:52 GMT

Hi Rob,

there is another way to come to the same result. Look at this:

Sales is 'Sum(Sales') and I added a second expression marking 'Invisible' and 'Bar'. Style is 'Stacked'.

The trick is to divide Sum(<Month =>} Sales by a number which is far larger than max(sum(sales)). So you cannot see the contribution of 'Invisible Sales' and the resulting bar looks like 'Grouped'.

Regards

Burkhard

Re: Control Bar width in Bar Chart

veidlburkhard — Wed, 09 Mar 2016 19:26:17 GMT

Hi Rahul,

then you have to use Sum({<Year =, Month=>} Sales)...

Hope this helps

Burkhard

Re: Control Bar width in Bar Chart

swuehl — Wed, 09 Mar 2016 19:43:35 GMT

You can also get rid of the transparent background coloring by using an expression like

=sum(Sales)+sum({1} 0)

and disabling 'suppress zero values' on presentation tab.

Re: Control Bar width in Bar Chart

rubenmarin — Wed, 09 Mar 2016 20:09:13 GMT

Hi Rahul, if you have checked the 'Supress when null' option this doesn't work, probably there are other reasons that makes that don't work so I will try the +sum({1} 0) proposed by swuehl

Re: Control Bar width in Bar Chart

Anonymous — Wed, 09 Mar 2016 20:10:51 GMT

Sure Ruben.

Re: Control Bar width in Bar Chart

rwunderlich — Thu, 10 Mar 2016 16:12:23 GMT

In my example, all bars are plotted regardless of how many months are selected.

-Rob

Re: Control Bar width in Bar Chart

marcus_sommer — Fri, 11 Mar 2016 07:52:21 GMT

One addition to the suggestion from Rob is a possible adjustment to dimension-values on the axis to show only the selected one per calculated dimension:

=dual(if(aggr(count(distinct Month), Month) > 0, Month, ''), Month)

- Marcus