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

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
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!

Labels (1)
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
Support
Support

1) Change your dimentions order

2) At Style tab, configure properly

Clever_Anjos
Support
Support

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
Support
Support

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
Support
Support

Please let me know if you need more help

MarcoWedel
MVP
MVP

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