topic Re: Stacked Bar Chart Issue in QlikView

Stacked Bar Chart Issue

shannoypaul — Mon, 21 Apr 2014 14:30:10 GMT

Hello Everybody,

I have one dimension and 4 expressions.

I am using a stacked bar chart. Since one expression aggregates to a very large value when compared to other expressions I cannot see the values for other expressions.

Thanks in advance

Re: Stacked Bar Chart Issue

Mon, 21 Apr 2014 14:48:31 GMT

Are you open to using other presentations? Maybe you can use a mixed chart and have the Large expression's shown differently (line) and it's axis on the other side, so the smaller expressions can be more visible.

Re: Stacked Bar Chart Issue

shannoypaul — Mon, 21 Apr 2014 14:58:15 GMT

Nope

Re: Stacked Bar Chart Issue

pgrenier — Mon, 21 Apr 2014 15:04:24 GMT

Patrick, excellent idea!

Also, in some cases, using the Log Scale for your main axis might help you offer a better visualization of your data.

Regards,

Philippe

Re: Stacked Bar Chart Issue

shannoypaul — Mon, 21 Apr 2014 15:10:39 GMT

I just confirmed it is client requirement

Re: Stacked Bar Chart Issue

Mon, 21 Apr 2014 15:20:17 GMT

In that case maybe you can present the original stacked chart as per their requirement, as well as alternative charts. Show them you can present their data more effectively.

Don't let the requirements limit the capabilities 😃 HTH!