Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Mirrored Y axis chart

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.

Picture1.png

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?

5 Replies
sushil353
Master II
Master II

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

susovan
Partner - Specialist
Partner - Specialist

Hi Fikri,

You can try this way,32.JPG

Warm Regards,
Susovan
Not applicable
Author

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!

Anonymous
Not applicable
Author

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.

Anonymous
Not applicable
Author

Hi Sushil, Susovan,

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