topic Re: Formatting a Stacked Bar Chart in QlikView

Formatting a Stacked Bar Chart

Anonymous — Wed, 04 Feb 2015 18:53:43 GMT

I have created a stacked bar chart in which I want to place the values of the data points. When the segment of the chart is too small the value does not appear (unless you mouse over the area and you see a pop up).

How do I force the segments to be larger so the values will appear in the chart. I have tried placing values in the Static Min value for each of the segments but nothing seems to work. See the circled areas below that where there are no values shown.

I have attached a sample Qlilview app with this chart.

Can anyone provide me with any ideas as to how to display all the values within the chart?

Thanks,

Ed T.

Re: Formatting a Stacked Bar Chart

Anonymous — Wed, 04 Feb 2015 19:00:24 GMT

You can do it by changing static min, max and step in axis. I have done in your app, 1 appears in first chart. Please find attached

Re: Formatting a Stacked Bar Chart

Anonymous — Wed, 04 Feb 2015 19:11:36 GMT

How did you determine the values to use in the static min, max and step in axis?

Re: Formatting a Stacked Bar Chart

Anonymous — Wed, 04 Feb 2015 19:23:48 GMT

I play with different possible scale to get the idea.

Re: Formatting a Stacked Bar Chart

Anonymous — Wed, 04 Feb 2015 19:25:23 GMT

Thanks for the help. I will keep "playing" with this to see if I can get better results.

Re: Formatting a Stacked Bar Chart

agomes1971 — Wed, 04 Feb 2015 19:27:48 GMT

Hi,

see my approach...

Regards

André Gomes

Re: Formatting a Stacked Bar Chart

Anonymous — Wed, 04 Feb 2015 19:33:33 GMT

It looks like you simply made the chart larger so it would show the data. Unfortunately I am under some size constraints on my production application and need to stick to the my original sizes for the chart.

Thanks.

Re: Formatting a Stacked Bar Chart

Anonymous — Wed, 04 Feb 2015 19:37:17 GMT

He has also made the font within the chart smaller.

Re: Formatting a Stacked Bar Chart

Anonymous — Wed, 04 Feb 2015 19:42:56 GMT

Changing some segments distorts information, defying the meaning of the chart. I'd recommend to use grouped, horizontal, if numbers must be shown

Re: Formatting a Stacked Bar Chart

Anonymous — Wed, 04 Feb 2015 19:47:08 GMT

I agree with you that this will misrepresent the data in the chart. However the customer requirements are for a vertical stacked bar chart and as we all know "The customer is always right".

Thanks for the feedback.

Re: Formatting a Stacked Bar Chart

saurabh5 — Wed, 04 Feb 2015 20:19:41 GMT

Hi Ed,

you can have a work around by creating copy of the same graph in larger size and allow maximize and minimize capability for the graph, which will enlarge when clicking on caption, and you can layer this graph above the smaller graph.So when minimized state the other smaller version of the graph will be visible.

Regards

Saurabh

Re: Formatting a Stacked Bar Chart

Anonymous — Wed, 04 Feb 2015 20:33:00 GMT

Indeed.
But, why do you need a copy? Just use "Maximize" button which is there already...

Re: Formatting a Stacked Bar Chart

Anonymous — Wed, 04 Feb 2015 20:43:52 GMT

Your right, Maximize is probably the best solution here.

Thanks.

Re: Formatting a Stacked Bar Chart

saurabh5 — Wed, 04 Feb 2015 20:47:15 GMT

yes, i said to have two graphs so that in default(graph 1) will fit in the size as per requirement and then place the graph 2 tab (minimized) state at the caption of 1st graph so that user has the power to maximize if they want.

Regard

Saurabh