Stacked chart

[D19PAL]

Hi,

I've got a sales table and a targets table joined with id

SALES
ID	SALES
1	10
2
3	50

left join

TARGETS
ID	Targets
1
2	29
3	30

My table in Qlik sense

FACT TABLE
id	sales	targets
1	10
2		29
3	50	30

What I need is to create a stacked bar chart, shall i create the table below? if so how, or can I use 2 measures as two aggregated fields as a stacked bar chart, or will i need to create the table below?

Need
id	sales or target	figures
1	sales	10
2	sales
3	sales	50
1	target
2	target	29
3	target	30

Thanks 

[jneppl]

Hi @D19PAL 

you can use your FACT TABLE. Create a bar chart, add id as dimension, add two measures for sales and targets. Go to presentation and choose "stacked".

I hope this helps.

Regards

[D19PAL · Accepted solution]

Cool, that's worked, but I used a date field as a Dimension.

Now, the for example the stacked bars show sales £70, targets £30, how can I make the bars show as percentage? sales in bar chart colour red (for example )70%

sales in bar chart colour blue (for example )30%