Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Combo Chart

Hi

I wonder if it is possible to combine two lines with different expressions, one negative and one positive, and then let a bar show the difference between them.

Like this:

 

Seaweed2.png

 

Measure 1 (negative)

Sum( {<$(vL_StandardDimVol),Flodesid={'I'}>} BeloppSEK_AO)
/
Sum( {<$(vL_StandardDimVol),Flodesid={'I'}>} KvantitetTon_AO)

 

Measure 2 (positive)

Sum( {<$(vL_StandardDimVol),Flodesid={'U'}>} BeloppSEK_AO)
/
Sum( {<$(vL_StandardDimVol),Flodesid={'U'}>} KvantitetTon_AO)

 

Thanks,

Daniel

 

Labels (2)
1 Reply
Highlighted
Partner
Partner

Hello Daniel,

 

It is possible but keep in mind, it's a bit of a workaround. Actually you need to create a bottom white bar and have the bars stacked.

Practically to achieve this, you need 5 measures (check my legend). In essence, the Bottom Line and Bottom Blank Bar are exactly equal but they need to be separated, so you can control the Background for the bottom bar and make it something transparent (I made mine white).

image.png

Result in QV:

image.png