Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
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.