topic Re: Chart bunches up when multiple dimensions in QlikView

Chart bunches up when multiple dimensions

Anonymous — Wed, 06 Jan 2016 14:12:57 GMT

I'm comparatively new to QlikView, but have managed a few dashboards successfully. My latest however is really tricking me in the way the chart is laid out.

The challenge lies in me having multiple dimensions represented hierarchically: business units grouped within region.

If I only have Business Unit as a dimension, the chart is great:

If I only have Region, also great. However if I have both the formatting turns out awfully, with thin lines, uneven spacing, and bars not aligned to their labels:

Has anyone come across this before? Both the data and the QVW are attached - would be grateful for any insights.

Thanks

Andrew

Re: Chart bunches up when multiple dimensions

Anonymous — Wed, 06 Jan 2016 16:36:08 GMT

If you change your Charts Properties -> Style -> Subtype -> Stacked. That might make it look better.

Re: Chart bunches up when multiple dimensions

awhitfield — Wed, 06 Jan 2016 16:49:10 GMT

Hi Andrew,

On Dimension, promote Region above Business Unit, then on style, change the subtype to stacked.

Chart then looks much better

HTH

andy

Re: Chart bunches up when multiple dimensions

Anonymous — Thu, 07 Jan 2016 08:15:25 GMT

Thanks Gents, that does make a difference. However I think I've found the underlying issue: Each Business Unit only exists in 1 country. When I group by country as a dimension, the chart creates empty columns for every Business Unit in every Country. Eg. if I select only 2 countries you can see units 211-246 only have data for South Africa, yet are repeated as empty columns for Tanzania:

I've tried suppressing Zero-Values an Missing values but no luck. Ideally I want a chart that only shows the Business Units within a region that has data - in other words a graphical representation of the below table:

Thanks

Andrew