Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik Expert,
I'd like to create a chart like this where the two expressions are plotted vertically up and bottom of Y axis.
I tried using Combo chart and split the axis for each expression but the chart does not mirror like the above. Any clue how this can be done?
hi,
In the simple bar chart you can achieve this. Just create a another expression with a negative sign. like below:
expression 1: sum(Sales)
expression 2: -Sum(Sales)
not in the style property of chart check the option for "Stacked"
HTH
Hi Fikri,
You can try this way,
Use expression to create the mirror value in the graph. For more, you can create the mirror value as field two, then just show more dimension is okay!
Hi Sushil,
I did this before but it did not show what I expected. When the chart is stacked it did not even show split axis.
Hi Sushil, Susovan,
I missed a step in the properties. Your suggestion works. Thanks!