topic Re: Bar charts grouping in QlikView

Bar charts grouping

Wed, 21 Jan 2015 12:00:22 GMT

Hi Guys!

I have a problem, my bar chrat looks like this (bar.Png)

And it should look like this (chart.png)

Can anyone help me out what to put in the dimensions and expressions box and which markers i have to check.

Thx in advance!

Re: Bar charts grouping

Gysbert_Wassenaar — Wed, 21 Jan 2015 12:12:10 GMT

Change the Orientation setting on the Style tab. Add a reference line on the Presentation tab.

Re: Bar charts grouping

Clever_Anjos — Wed, 21 Jan 2015 12:16:01 GMT

1) Change your dimentions order

2) At Style tab, configure properly

Re: Bar charts grouping

Clever_Anjos — Wed, 21 Jan 2015 12:18:59 GMT

One question came up to my mind

"Shared Knowledge" and others are one dimension or 4 different expressions?

Re: Bar charts grouping

Wed, 21 Jan 2015 13:11:57 GMT

At the moment they are 4 different expressions

Re: Bar charts grouping

Wed, 21 Jan 2015 13:13:00 GMT

Im wondering wheter i should make them dimensions, since they are sort of grouped in the example image

Re: Bar charts grouping

Clever_Anjos — Wed, 21 Jan 2015 13:29:53 GMT

If you´re using different expressions, you can´t do like that.

You should rearrange your data to use two dimensions

Re: Bar charts grouping

Wed, 21 Jan 2015 13:37:46 GMT

Thanks, then i will solve it differently:)

Re: Bar charts grouping

Clever_Anjos — Wed, 21 Jan 2015 13:44:28 GMT

Please let me know if you need more help

Re: Bar charts grouping

MarcoWedel — Wed, 21 Jan 2015 16:13:21 GMT

one possibility could be to create a calculated dimension using

=Valuelist('ExpressionName1', 'ExpressionName2', 'ExpressionName3', 'ExpressionName4')

and one combined expression like

=Pick(Match(Valuelist('ExpressionName1', 'ExpressionName2', 'ExpressionName3', 'ExpressionName4'),

'ExpressionName1', 'ExpressionName2', 'ExpressionName3', 'ExpressionName4'),

insert Expression1 here,

insert Expression2 here,

insert Expression3 here,

insert Expression4 here

)

hope this helps

regards

Marco