Hi All - I am attempting to create a bar chart with three dimensions, with the third dimension appearing as stacked colors (please see pic below). I know that you cannot add 3 dimensions in a conventional sense to a bar chart, however I was hoping I could use the "color by dimension" option to color the bars by that third dimension. When I try this, all the bars turn grey. Can anyone please confirm the right syntax to use to get this to work, or if this is simply impossible in Qlik.
And, if impossible, does anyone know of any extensions or workarounds I can use? I've seen this topic posted before in the forums, but haven't found any conclusive answers or alternate suggestions.
Thanks!
EXAMPLE;