topic Re: Re: Problem with Stacked Bar Chart in QlikView

Problem with Stacked Bar Chart

Wed, 03 Sep 2014 16:00:45 GMT

I have a stacked bar chart that combines invoiced sales with open sales. I group by location then by year. This works fine.

The problem happens when I introduce a symbol to represent budget values. The symbols appear on the same line (location) and don't appear over the bars associated with their year. My small attachment isolates and demonstrates the problem. Can someone help? Thanks.

Re: Problem with Stacked Bar Chart

IAMDV — Wed, 03 Sep 2014 16:23:56 GMT

Hi Brian,

I'm afraid but it seems to be design defect to me. I don't see any setting to move the symbols. Sorry, not very helpful!

www.QlikShare.com

Re: Problem with Stacked Bar Chart

Wed, 03 Sep 2014 16:39:20 GMT

Perhaps you could use trellis as an alternative?

Example attached.

Re: Problem with Stacked Bar Chart

Wed, 03 Sep 2014 18:41:20 GMT

How disappointing if there's no answer and this proves to be a bug/defect.

I could possibly work with the Trellis Chart (and thank you), but the example you posted shows a lot of wasted real estate. For instance, why does the graph scale out to 100,000 when the maximum value of any bar is ~30,000? Also it would be nice to have the location labels off to the side rather than over the top of each graph. I'm not sure there's a way to do that...

Re: Re: Problem with Stacked Bar Chart

Wed, 03 Sep 2014 20:36:57 GMT

I have never been able to find a way to move the trellis labels. You could use text objects or a transparent overlay as a work-around, but obviously this isn't ideal.

Attached is a copy with a scaling solution for the trellis chart and one other option that might be worth a look.

Re: Re: Problem with Stacked Bar Chart

Thu, 04 Sep 2014 12:42:00 GMT

I plan to report this as a bug to QlikView.

As for your workarounds, I think they're best options given the nature of the problem. Thanks for taking the time.

Re: Re: Problem with Stacked Bar Chart

Fri, 05 Sep 2014 19:08:16 GMT

Hi Clark. I like your alternative approach here which concatenates location and year as a single dimension. Do you see a way to sort the bars in the same manner as the trellis chart -- that is, ascending by 2014 sales with corresponding 2013 sales just below each bar? I'm struggling with this right now and don't see an easy way...