topic Preference of overlapping bar chart in QlikView

Preference of overlapping bar chart

stevenkasian — Wed, 25 Nov 2020 16:16:04 GMT

I have a overlapping bar chart showing current version revenue forecast VS last month version VS Plan

I want current version to the left, last month in the middle and Plan at the right.

But I also want current version above last month and then above Plan.

Now the Qlik bar chart seems do not let me set this preference, but just the right bar above the left ones.

Anyone can kindly help me with this?

Thanks!!

Re: Preference of overlapping bar chart

Anonymous — Wed, 30 Mar 2016 07:16:50 GMT

Hi,

You can try, press ctrl+Shift to move the chart and resize them around to get what you need. Also go to properties->general then click on reset user resizing to allow resizing to be easier.

Alternatively, please upload a sample qvw to make it easier for us to help

Re: Preference of overlapping bar chart

Chanty4u — Wed, 30 Mar 2016 07:54:14 GMT

u can make changes by using

cntrl+shift select ur chart and move ur positions and

chking below options in general tab

Re: Preference of overlapping bar chart

niceqlik — Wed, 30 Mar 2016 07:56:31 GMT

Hello,

if the order of your expressions is not that important, you can set Bar Distance parameter with minus values (-4) and Cluster Distance with positive (8). It is under Properties->Presentation section.

This allows a little overlapping over expressions but the limitation is that the very last expression always overlaps the previous one.

Re: Preference of overlapping bar chart

stevenkasian — Wed, 30 Mar 2016 17:12:34 GMT

Thanks for all the replies and the willingness to help!

Let me upload the example here.

The format I want to show in this overlapping bar chart is:

1. From left to right: Forecast > Forecast (Last Month) > Plan

2. Overlapping: from left to right also, which means Forecast > Forecast (Last Month) > Plan

As Ismail said, the very last expression, which is the right one always overlaps the left ones.

Thanks Ismail for the suggestion. I have also tried that before but I think users will still be distracted but that transparency.

Since we used to read data and charts from left to right, I hope the current Forecast (which is supposed the most important information) stands out by putting it at the left but not overlapping by other charts. I hope there is some trick way I can do that