topic Re: Bar chart in QlikView

Bar chart

Anonymous — Wed, 09 Nov 2016 11:38:43 GMT

Hello everyone.

I would like to know if it is possible to create a graph of this, that when the bar is

too large the values pass into the segment automatically. Or the opposite, I set

up a chart with the values inside the segment and when the bar is small the

values appear on the bars.

Re: Bar chart

sunny_talwar — Wed, 09 Nov 2016 12:26:08 GMT

I don't think you will be able to achieve this using the inbuilt QlikView functionalities.

Re: Bar chart

Anonymous — Wed, 09 Nov 2016 12:47:08 GMT

Hi,

In my experience, having values displayed next to the bar usualy auto scales unless you change a whole bunch of properties and custom layouts.

Does the usual scaling cut off your values or is that your requirement to make the unusualy large bar stand out?

If your chart is getting cut off, I'd suggest recreating the bar chart using the required dimension and expression and see if it displays all vaules. Then add on the formatting and see what causes it to get cut off.

As you can see below, the chart displays correctly and does not get cut off...Qvw attached as well.

Re: Bar chart

stigchel — Wed, 09 Nov 2016 12:54:34 GMT

Something like this? See atached

Re: Bar chart

Wed, 09 Nov 2016 13:01:28 GMT

May be you can try like mentioned in attached image.

Define your axis range

Re: Bar chart

Anonymous — Wed, 09 Nov 2016 13:13:08 GMT

That's it, Stigchel.

You used bars and lines.

I tried to reproduce, but it did not look the same. The values appear within the segment and on the bars. What did I stop? Follows attached.

Re: Bar chart

stigchel — Wed, 09 Nov 2016 14:10:26 GMT

Hi Marcio,

I use the text color expression of the line expression to hide the text when it is not needed.

Re: Bar chart

Anonymous — Wed, 09 Nov 2016 14:44:22 GMT

Hi, Stigchel.

Okay, it worked.

Thank you.