How to create a stacked bar chart with many categories?
I want to create a stacked bar chart like this. However, the categories exceed the number of measure allowed in Qlik sense Saas. I can only add a measure as an alternative measure now. What should I do?
This probably is a single measure, like sum(Sales), but it is split out among two different dimensions. In this case, one dimension is Month; and the other is for example Department.
If you format the data in this shape:
Month, Department, Sales
May, Boats, 3
May, Cars, 4
June, Boats, 2
June, Cars, 4
July, Boats, 3
July, Cars, 6
etc...
Then you can create a stacked bar chart with two dimensions and just a single measure.
This probably is a single measure, like sum(Sales), but it is split out among two different dimensions. In this case, one dimension is Month; and the other is for example Department.
If you format the data in this shape:
Month, Department, Sales
May, Boats, 3
May, Cars, 4
June, Boats, 2
June, Cars, 4
July, Boats, 3
July, Cars, 6
etc...
Then you can create a stacked bar chart with two dimensions and just a single measure.
