Just thinking if it is possible to create this type of chart in QlikView? A snapshot is attached.
Basically, each bar is divided in three pieces/expressions.
Upper part is total sales(+ve value), Lower part is total redemption (-ve value), and the middle part is Net Sales (+ve or -ve).
Tried candle stick chart but does not look good. Using stacked bar chart is better option, but its Y-axis cant be floating as you can see in the snapshot. The 0 value of the Y axis will always be in the middle, so that does not work.
