topic Remove Spaces between bars in bar chart in QlikView

Remove Spaces between bars in bar chart

nagarajupinnibo — Wed, 26 Mar 2014 06:44:36 GMT

Hi,

I had created a bar chart which contains spaces between bars. I need to remove spaces and combine bars.

I attached a document for it..

Even I changed cluster distance and bar distances also, but spaces are not removed

Please look at this document and provide solution for it..

Thanks,

-Nag

Re: Remove Spaces between bars in bar chart

Wed, 26 Mar 2014 06:50:21 GMT

Check Suppress when value is Null in Dimension tab

Re: Remove Spaces between bars in bar chart

nagarajupinnibo — Wed, 26 Mar 2014 07:10:12 GMT

Hi Neha,

I already checked it. But, spaces are not removed..

Re: Remove Spaces between bars in bar chart

Wed, 26 Mar 2014 07:18:26 GMT

Hi,

Can you upload sample document..

Thanks

Re: Re: Remove Spaces between bars in bar chart

nagarajupinnibo — Wed, 26 Mar 2014 08:05:04 GMT

Hi Sathiyasarathy,

I attached sample document and Excel file.. When you open document, u can see spaces between bars.. needs to merge bars and remove spaces.

Re: Re: Re: Remove Spaces between bars in bar chart

Wed, 26 Mar 2014 08:25:19 GMT

Hi,

Might be something like attached.

Re: Re: Remove Spaces between bars in bar chart

nagarajupinnibo — Wed, 26 Mar 2014 08:33:39 GMT

Hi Shyamal,

In document, dimension b values merged with dimension a values.. But, I need dimension a values gets merged, dimension b values gets merged separately.

Thanks

-nag

Re: Remove Spaces between bars in bar chart

semperaugustus — Wed, 26 Mar 2014 08:36:53 GMT

I think that it's impossible.

"Suppress when value is null" hide the dimension if the value is null,

"Suppress Zero-value" hide the Whole dimension only if all the expressions return 0.

in your case the space for the columns is fixed,so if an expression returns 0 the column is invisible but can't be suppressed

Re: Remove Spaces between bars in bar chart

Wed, 26 Mar 2014 08:47:14 GMT

Hi Nag,

Just modify the chart by increasing the cluster distance.

Re: Re: Remove Spaces between bars in bar chart

nagarajupinnibo — Wed, 26 Mar 2014 08:52:34 GMT

Hi Shyamal,

I already done it.. I didn't get the solution for it. Iam getting space between two dimensional bars..

But,I need to remove space for each dimension..

You can see it in my example, there is a space between 1 and 3 values of Y for dimension a.

Thanks

-Nag

Re: Remove Spaces between bars in bar chart

Wed, 26 Mar 2014 09:48:50 GMT

Hi,

For the merged dimensions why cant you try the stack option which will look like this..Anyway you don't want to show null values..

Thanks

Re: Remove Spaces between bars in bar chart

ThornOfCrowns — Wed, 26 Mar 2014 09:54:42 GMT

You can't get bars to edge up to each other nor overlap as you can in other applications.

Re: Re: Remove Spaces between bars in bar chart

nagarajupinnibo — Wed, 26 Mar 2014 10:00:06 GMT

Hi Sathiyasarathy,

I added it as stacked bar chart. Iam finding for, is there any possibility to remove spaces under grouped bar chart.

Is it possible or not??

Re: Remove Spaces between bars in bar chart

mangalsk — Wed, 26 Mar 2014 10:13:49 GMT

hello,

It is possible using stacked bar

Re: Re: Remove Spaces between bars in bar chart

Wed, 26 Mar 2014 10:17:07 GMT

Hi Nagaraju,

It is possible only in stacked view..

Thanks

Re: Remove Spaces between bars in bar chart

Wed, 26 Mar 2014 10:21:55 GMT

Yes, I understand that.

But I think this is not possible using grouped option.You can try using teh stacked option as suggested by Sathiyasarathy.

Re: Re: Remove Spaces between bars in bar chart

nagarajupinnibo — Wed, 26 Mar 2014 10:27:51 GMT

Thanks all for your valuable inputs..

Re: Remove Spaces between bars in bar chart

francescoasaro — Fri, 10 Jun 2016 08:19:25 GMT

Two years later, this is still a issue. Can't hide those blank spaces between bars.

Re: Remove Spaces between bars in bar chart

Fri, 10 Jun 2016 18:10:56 GMT

Hi Nag and all!

Impossible? Not exactly! See my attached application. I'm sure you can improve it!

Please, let me know what you think!

Best regards,

Marcello

Re: Remove Spaces between bars in bar chart

ThornOfCrowns — Mon, 13 Jun 2016 09:01:56 GMT

Nice work, but you're essentially hand-tooling the result. What if you wish to quickly add a new set of data with 10 points, or 100?