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?

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.