Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
MVP
MVP

Re: Creating a Stacked Bar Chart

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

5 Replies
MVP
MVP

Re: Creating a Stacked Bar Chart

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

Highlighted
Not applicable

Re: Creating a Stacked Bar Chart

Thanks Oleg, that works great. Much appreciated.

Not applicable

Re: Creating a Stacked Bar Chart

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

Re: Creating a Stacked Bar Chart

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

MVP
MVP

Re: Creating a Stacked Bar Chart

Arun,

1st dimension: Year

2nd Dimension: Site

Convert to stacked bar chart under Presentation properties