topic Re: Gap between bars in Bar Chart in QlikView

Gap between bars in Bar Chart

Mon, 28 Jul 2014 08:56:33 GMT

Hi,

I have a bar chart and would like the gaps between the bars values to appear.

For example, in the attachment, the first 2 bars have 429 252 and 566 269 as values.

I would to show he gap between ( 566 269 - 429 252 ) , 137 017.

Since the dimension is a group, it has to be dynamic ( between monthes, weeks or days..)

Is it possible?

Thanks,

Yael

Re: Gap between bars in Bar Chart

Mon, 28 Jul 2014 10:58:23 GMT

Hi,

Can you attach your sample data ??

Re: Gap between bars in Bar Chart

dharmarasu — Mon, 28 Jul 2014 11:08:56 GMT

Hi,

Bar chart -> presentaion tab ->Cluster Distance->8

Hope this helps.

Dharma

Re: Gap between bars in Bar Chart

Mon, 28 Jul 2014 11:53:29 GMT

Hi Dharma,

I don't want the distance between the bars to be changed, I want that the difference between the values will be shown.

Thanks.

Re: Gap between bars in Bar Chart

MarcoWedel — Mon, 28 Jul 2014 13:33:29 GMT

maybe using a combo chart instead of just a bar chart. An additional expression2 shown as a line could calculate the changes of your bar expression1 if defined like =expression1 - above(expression1).

hope this helps

regards

Marco

Re: Gap between bars in Bar Chart

Tue, 29 Jul 2014 06:34:14 GMT

Thanks a lot, that works! I didn't know the "above" function.