Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How many expressions and dimensions can be usedin the bar chart?

Hi All,

How many expressions and dimensions can be usedin the bar chart?

Thanks,

Attitude

11 Replies
SunilChauhan
Champion
Champion

only two dimensions

and more than 1 expression

Sunil Chauhan
Not applicable
Author

Hi Sunil

I have heard that we can use 3 dimensions and only one expression.

Can someone please verify the answer given?

Thanks,

Attitude

hic
Former Employee
Former Employee

It is the same thing. A bar chart can have dimensionality=3, which you can achieve by either 2 dimensions and an array of expressions (any number of expressions), or 3 dimensions and single expression./HIC

Not applicable
Author

Hi Henric

So do you mean to say that maximum of 3 dimensionality can be used in bar chart?

Thanks,

Attitude

SunilChauhan
Champion
Champion

if we use third dimension then it will not appear in chart

Sunil Chauhan
Not applicable
Author

Hi Sunil

Yes you are correct I also think the same. But I heard someone saying that we can use 3 dimension in the bar chart. So I want some justification from those people.

Thanks,

Attitude

hic
Former Employee
Former Employee

Yes, you can use three dimensions and one expression. See attachment. But you can argue that the bar chart gets cluttered and that you should not do it..

Not applicable
Author

Hi All,

As the discussion is on Bar chart's dimension and expression limit, I am using two dimensions and more than two expressions, then my bar chart is automatically converted into stacked style which i dont want, I want to show my expressions in Bar only, can any one tell me how to do that?

Regards,

Yojas

whiteline
Master II
Master II

Add a synthetic dimension (the last one):

=ValueLoop(1,2)

Then you can replace your 2 expressions with one:

=pick(ValueLoop(1,2), expression1, expression2)