Stacked bars, create table or can I use set analysis

D19PAL — Mon, 08 Feb 2021 11:46:27 GMT

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

Re: Stacked bars, create table or can I use set analysis

joseph_morales — Mon, 08 Feb 2021 14:50:43 GMT

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,

topic Stacked bars, create table or can I use set analysis in QlikView

Stacked bars, create table or can I use set analysis

Re: Stacked bars, create table or can I use set analysis