topic Re: can we do this in Bar chart in QlikView

can we do this in Bar chart

narband2778 — Fri, 22 Nov 2013 15:35:03 GMT

Gi guys,

I have two expressions in my bar chart and are over stacked.

which means the second bar is stacked on first bar, but can we start the second bar from the x-axis (i.e. from value 0) where the first bar starts with? (instead of stacking it up on the second bar)

regards,

Naresh

Re: can we do this in Bar chart

Nicole-Smith — Fri, 22 Nov 2013 15:46:48 GMT

Change to Grouped instead of Stacked:

Re: can we do this in Bar chart

narband2778 — Fri, 22 Nov 2013 15:54:04 GMT

hey thanks for that but both the charts should be overlapped and should start from axis.

Re: can we do this in Bar chart

Nicole-Smith — Fri, 22 Nov 2013 16:06:59 GMT

You can't do it on a normal bar chart. You either need to have two bar charts with one laid over the other one with the top one transparent or you need to create an extension object. Having two overlaid is probably not recommended as you could end up with dimensions being different on both and then things won't line up properly.

Re: can we do this in Bar chart

MK_QSL — Fri, 22 Nov 2013 16:14:02 GMT

Hi... chart can't be overlapped in QlikView but you can reduce the spaces between two bars.

Go to Presentation

Bar Setting and do the Bar Distance -6

Re: can we do this in Bar chart

narband2778 — Fri, 22 Nov 2013 16:37:19 GMT

thanks manish

Re: can we do this in Bar chart

narband2778 — Fri, 22 Nov 2013 16:37:28 GMT

thanks nicole