Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hello Midchen,
Kindly please follow this link I guess it should help to solve with your problem.
Hello Midchen,
Kindly please follow this link I guess it should help to solve with your problem.
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.