Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 1 | Field 1 | Field 2 | Field 3 | Total |
---|---|---|---|---|
1 | 20 | 30 | 50 | 100 |
... | ... | .... | ... | ... |
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
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
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
Thanks Oleg, that works great. Much appreciated.
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
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
Arun,
1st dimension: Year
2nd Dimension: Site
Convert to stacked bar chart under Presentation properties