We are having a scenario where we have to implement waterfall chart in qlikview which has a stacked bar at the end.
Please find below screenshot for reference:
In above scenario, the issue we are facing is when we are entering expression for bar offset, the value is automatically adding up in the base expression.
E.g.: For expression 1, the value shown is 2000 which is correct.
For expression 2, the value 250 must be displayed, instead when we apply bar offset with value 2000 from 1st expression, the value on data point is showing 2250 (Exp1: 2000 + Exp2: 250). Same is the case with remaining expressions except for the last stacked bar.
Kindly suggest if there is any work around to achieve the desired result.