One column positive value above x-axis and 2nd column positive values below x-axis in a stacked bar chart - Qlik sense

[manisha10]

Hi All!

I have a table with columns Inflow and Outflow.  I want to display Inflow values above x-axis and Outflow values below x-axis in a stacked bar chart. Both are positive. 

Table:

Time	forward	Current	Inflow	Outflow
Jan	A	A	255	801
Jan	A	B	300	424
Jan	A	C	444	964
Jan	B	A	121	181
Jan	B	B	500	966
Jan	B	C	600	409
Jan	C	A	337	508
Jan	C	B	700	775
Jan	C	C	899	327

Desired Output:

Qlik Sense Business 

[rubenmarin]

Hi, I think you will need to split Inflow and outflow values to show as different dimensions, and use color setting to visually merge in one dimension.

Also you can use tooltip section to show all values positive.

Sample attached.

[manisha10]

can you please explain the step by step process with code? I'm unable to access the file. 

[rubenmarin]

Hi, you can import the app to sense so you can see how it's done. If you are using qlik desktp you only need to drag the app or copy it to Documents\Qlik\Sense\Apps.

When opened check the script to see how the values are splitted.

In chart properties check the dimension and expression, and in the apparance section the color and tooltip setting