Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand
Clever_Anjos
Employee
Employee

1) Change your dimentions order

2) At Style tab, configure properly

Clever_Anjos
Employee
Employee

One question came up to my mind

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

Not applicable
Author

At the moment they are 4 different expressions

Not applicable
Author

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


Clever_Anjos
Employee
Employee

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

You should rearrange your data to use two dimensions

Not applicable
Author

Thanks, then i will solve it differently:)

Clever_Anjos
Employee
Employee

Please let me know if you need more help

MarcoWedel

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