topic Re: Stack bar chart : How to show values in small segment. in QlikView

Stack bar chart : How to show values in small segment.

Anonymous — Mon, 21 Sep 2015 12:11:12 GMT

Hi All,

In one of the user requirement I need to plot a region wise stacked bar chart against purchase amount & sales amount. I have plotted the chart but smaller segment ( in this case purchase amount) values are not getting displayed on the chart.

I am attaching the screen shot of my stacked bar chart as below :

Can anyone help me with any ideas to display purchase amount value in the chart?

Re: Stack bar chart : How to show values in small segment.

stigchel — Mon, 21 Sep 2015 12:19:11 GMT

If the segments get too small the values won't be displayed by qlikview. There is no setting to change that, a work around could be to copy the expression and uncheck bar display and check Text on axis. It will display the values below the axis.

Re: Stack bar chart : How to show values in small segment.

sudeepkm — Mon, 21 Sep 2015 12:26:53 GMT

Try to adjust the scale by using the properties given below. for example try using static step as 200.

you can use the min value as 200 (you can make it data driven instead of static/hard coded) as the lowest one is 259.

Re: Stack bar chart : How to show values in small segment.

Anonymous — Mon, 21 Sep 2015 13:21:22 GMT

Thanks Piet & Sudeep for quick reply.

Sudeep I have tried your approach, it helps but not completely.