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

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

Midchen — Sun, 24 Apr 2022 08:13:17 GMT

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?

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

Shalom — Mon, 25 Apr 2022 01:23:00 GMT

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/td-p/357098

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

Midchen — Mon, 25 Apr 2022 03:04:36 GMT

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.