Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Shell_n
Partner - Contributor
Partner - Contributor

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? 

The target visualization:

Shell_n_0-1685585893455.png

 

 

 

Labels (3)
1 Solution

Accepted Solutions
do_Ob
Contributor II
Contributor II

You should rework your data.

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.

 

View solution in original post

1 Reply
do_Ob
Contributor II
Contributor II

You should rework your data.

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.