topic Re: Mirrored Y axis chart in QlikView

Mirrored Y axis chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Mirrored Y axis chart

sushil353 — Fri, 01 Jul 2016 04:58:43 GMT

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

Re: Mirrored Y axis chart

susovan — Fri, 01 Jul 2016 05:01:51 GMT

Hi Fikri,

You can try this way,

Re: Mirrored Y axis chart

Fri, 01 Jul 2016 05:32:35 GMT

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!

Re: Mirrored Y axis chart

Anonymous — Fri, 01 Jul 2016 06:20:34 GMT

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.

Re: Mirrored Y axis chart

Anonymous — Fri, 01 Jul 2016 06:31:21 GMT

Hi Sushil, Susovan,

I missed a step in the properties. Your suggestion works. Thanks!