How to create a stacked bar chart coming from 2 tables - Qlik sense

[manisha10]

Hi All! 

I have a two tables. I have created stacked bar chart from 1 table. I want to add one more on this stacked bar chart and the amount is coming from a different table. 

Stacked bar chart from table 1: 

Desired Output: 

Thank you!

Qlik Sense Business 

[lironbaram · Accepted solution]

Hi , 

the bar chart has this limitation : 
you can either use 2 dimensions and 1 measure or 1 dimension and as many measures you want. 
you have 2 options: 
1 concatenate the two tables in the load script : 

Table1:
Load Month,
     [Asset class],
     Amount
From XXX;
concatenate (Table1)
Load Month,
     'Others' as [Asset class]
      [Total Amount] as Amount
From YYY;

Then you'll have a simple chart :
1st dimension: Month
2nd dimension:  Asset class
measure: Sum(Amount)
your second option is to leave the table as they are and to build this chart. 
dimension: Month

1st measure: sum(if([Asset class]='A', Amount)

2nd measure: sum(if([Asset class]='B', Amount)

3rd measure: sum([Total Amount])

[manisha10]

Hi @lironbaram thank you for the solution!! I used combo chart and added 3 measures with 3 different colours.