Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating a Stacked Bar Chart

Hello,

I am fairly new to Qlik Sense. I am having a problem creating a stacked bar chart, which is asking for 2 dimensions, and 1 measure. I have data in the form below

Dimension 1Field 1Field 2Field 3Total
1203050100
................
X.............

I would like to create a stacked bar chart with Dimension 1 as the X axis, and Total as the Y axis, and the bars divided into field 1, field 2 and field 3. However, I'm having problems as Qlik Sense seems to want a different data model to create this chart. Does anyone have any advice?

Thanks

1 Solution

Accepted Solutions
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi James,

Stacked bar charts can be created in two ways:

1. Two Dimensions, one Measure.

2. One Dimension, multiple Measures.

In order to create the chart in the first case, you need to load your data using the CROSSTABLE load. This way, your Field1, Field2, Field3 labels get loaded as values of an "Attribute Field" and your numeric totals get loaded as the "Data Field". The sum(Data Field) can serve as your Measure.

Otherwise, you can create a stacked bar chart with multiple measures:

sum(Field1)

sum(Field2), etc...

then, you don't have to do anything with your data structure.

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

View solution in original post

5 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi James,

Stacked bar charts can be created in two ways:

1. Two Dimensions, one Measure.

2. One Dimension, multiple Measures.

In order to create the chart in the first case, you need to load your data using the CROSSTABLE load. This way, your Field1, Field2, Field3 labels get loaded as values of an "Attribute Field" and your numeric totals get loaded as the "Data Field". The sum(Data Field) can serve as your Measure.

Otherwise, you can create a stacked bar chart with multiple measures:

sum(Field1)

sum(Field2), etc...

then, you don't have to do anything with your data structure.

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

Not applicable
Author

Thanks Oleg, that works great. Much appreciated.

Not applicable
Author

James

A tutorial you have how i can create stacked bar chart in qlik sense

I have sitename as dimension (Different sites)

          Year as Dimension

Netweight is measure

I want year as x -axis and Netweight as y axis and sitename as stacked bar graph. How i can do it pease help

Not applicable
Author

Any online tutorial you have how i can create stacked bar chart in qlik sense

I have sitename as dimension (Different sites)

          Year as Dimension

Netweight is measure

I want year as x -axis and Netweight as y axis and sitename as stacked bar graph. How i can do it pease help

I created a bar graph. I am stuck how to convert to stacked bar chart. Please help

Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Arun,

1st dimension: Year

2nd Dimension: Site

Convert to stacked bar chart under Presentation properties