Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Theo_Trumbic
Contributor
Contributor

Combo chart with negative values - '0' position between primary and secondary axis

Hello,

I am using a combo chart to show:

- Monthly revenue on the primary axis (left end side). Values can be positive or negative.

- Cumulative revenue on the secondary axis (right end side).

Showing the negative values from the primary axis impacts the secondary axis (the '0' on the secondary axis starts at the same position than the '-10' on the primary axis). I am able to get the 0s on the same position only by clicking on Auto range in appearance; however, the negative values form my monthly revenues then disappear from the visual.

I also tried RangeMin() and RangeMax() formulas to define my Min and Max - not working.

Does anyone know how I could show negative values - on the primary axis - while having the '0' from both axis in the same position?  

Thanks

Labels (2)
0 Replies