Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
D19PAL
Creator
Creator

Stacked chart

Hi,

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

 

SALES
IDSALES
110
2 
350

 

left join

TARGETS
IDTargets
1 
229
330

 

My table in Qlik sense

FACT TABLE
idsalestargets
110 
2 29
35030

 

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
idsales or targetfigures
1sales10
2sales 
3sales50
1target 
2target29
3target30

 

Thanks 

 

 

1 Solution

Accepted Solutions
D19PAL
Creator
Creator
Author

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%

 

 

View solution in original post

2 Replies
jneppl
Partner
Partner

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
Creator
Creator
Author

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%

 

 

View solution in original post