Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Modify axis in bar chart?!

Hi,

I want to know, if it is possible to modify an axis in an bar chart?

The problem is:

I´ve one dimension and two formulars, which have to be designed like the example. I´ve multiply the blue bars by -1 to get this design.

The problem is that I´ve negativ numbers on the x-axis, which are positiv in fact... In a table I could solve the Problem with the following numer format:

#.##0;#.##0;0

But it doesn´t work in a chart axis.

Have anyone an idea? 

Thanks in advance

1 Reply
IAMDV
Master II
Master II

Hi,

I had exactly same issue in the past. I could not change the negative Axes value to positive and still show on the left hand side. Fabs or multiplying by -1 will not work because it changes the display to the right. So I had to hide the Axes and show the Grid. Then I have used the TextBox to show the positive numbers. It is important to uncheck the position Allow Move/Size and also make your Axes range with Static Min and Static Max.

This is not 100% solution for your issue. But a workaround to get it working.

Good luck!

Cheers - DV