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: 
Midchen
Contributor II
Contributor II

Can bar charts be stacked and grouped in the same graph?

My field

[Month],
[Value1],
[Product],
[Value2],
[Status]

I want to use Month as the dimension, stack Value1 with Product and Value2 with Status, and the two bars can be compared together。
I found that QLIK can only choose between stacks and groups,Is there any way to help me achieve this?

Labels (1)
1 Solution

Accepted Solutions
Shalom
Contributor II
Contributor II

Hello Midchen,

 

Kindly please follow this link I guess it should help to solve with your problem.

https://community.qlik.com/t5/QlikView-App-Dev/Clustered-Stacked-Column-and-Bar-Charts-in-QlikView/t...

View solution in original post

2 Replies
Shalom
Contributor II
Contributor II

Hello Midchen,

 

Kindly please follow this link I guess it should help to solve with your problem.

https://community.qlik.com/t5/QlikView-App-Dev/Clustered-Stacked-Column-and-Bar-Charts-in-QlikView/t...

Midchen
Contributor II
Contributor II
Author

I tried it and it would only split into 2 strips, it wouldn't stack each dimension, I didn't know how to stack it.Maybe I'm not doing it the right way.

My two dimensions are Month and valuelist('v1','v2'),

My measure is the if (ValueList (' v1 ', 'v2') = 'v2', the Sum (Value2), if (ValueList (' v1 ', 'v2') = 'v1', the Sum (Value2))),I don't understand how to stack the values of V1 and V2 as product and status.I may have misrepresented myself, but my head is broken.

I haven't used QLIKview,I looked at the picture above , but I still don't understand how ActualA B C and ForecastA B C stack as measurements in the picture.