Stacked bars, create table or can I use set analysis

[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

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 

[joseph_morales]

Hi @D19PAL 

You don't need to create the last table, you can create the stacked bar chart with the table resulting from the join.

The result of the join:

Create a bar chart, I assume the dimension is ID, and as expressions SUM (SALES) and SUM (Targets)

In the styles tab, you choose the type of stacked bar.

Regards,