topic Re: Combo Chart in App Development

Combo Chart

danieladv — Sat, 16 Nov 2024 04:15:30 GMT

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:

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

Re: Combo Chart

Stoyan_Terziev — Mon, 28 Oct 2019 12:20:16 GMT

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).

Result in QV: