Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Bar charts grouping

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!

9 Replies

Re: Bar charts grouping

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


talk is cheap, supply exceeds demand
Employee
Employee

Re: Bar charts grouping

1) Change your dimentions order

2) At Style tab, configure properly

Employee
Employee

Re: Bar charts grouping

One question came up to my mind

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

Not applicable

Re: Bar charts grouping

At the moment they are 4 different expressions

Not applicable

Re: Bar charts grouping

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


Employee
Employee

Re: Bar charts grouping

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

You should rearrange your data to use two dimensions

Not applicable

Re: Bar charts grouping

Thanks, then i will solve it differentlySmiley Happy

Employee
Employee

Re: Bar charts grouping

Please let me know if you need more help

Re: Bar charts grouping

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

Community Browser