Skip to main content

App Development

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

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
danieladv
Partner - Contributor II
Partner - Contributor II

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 (1)
1 Reply
Stoyan_Terziev
Partner - Creator III
Partner - Creator III

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