Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
manisha10
Contributor III
Contributor III

How to create a stacked bar chart with two separate table - Qlik Sense

Hi All, 

I have two tables to be combined into a stacked bar chart. inflow values to be appeared above x-axis and outflow values should be below x-axis. 

Two table: 

Table1: 

TimeforwardCurrentInflow
JanAA255
JanAB300
JanAC444
JanBA121
JanBB500
JanBC600
JanCA337
JanCB700
JanCC899

 

Table 2:

TimeCurrentforwardOutflow
JanAA801
JanAB424
JanAC964
JanBA181
JanBB966
JanBC409
JanCA508
JanCB775
JanCC327

 

Qlik Sense Business 

4 Replies
lironbaram
Partner - Master III
Partner - Master III

Hi,
check this app for an example 

manisha10
Contributor III
Contributor III
Author

Hi @lironbaram thank you for the quick response!  Since I'm working on cloud. Can you please share the code and steps here?

This is the desired output : 

manisha10_0-1631515623228.png

 

lironbaram
Partner - Master III
Partner - Master III

Hi, 
There is no code to share.
The problem is that the chart you are trying  to create has two dimensions and two measures, 
And currently, no chart in Qlik sense supports this scenario.
The only option will be to use one dimension and  a lot of measures, but this is only usable if you have a limited number of values in the second dimension

manisha10
Contributor III
Contributor III
Author

Thank you @lironbaram for your guidance! I will make 2 graphs for the two tables then. 🙂