Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

negative to positive on y-axis

Hi all,

My expression gives back negative values, but I will show and plot them as positive values. In other discussions I have read that I could change the format patter to #,##0;#,##0, which works if the static step is 1. However, when the object adjusts his static stat to f.e. steps of 5, the '-' sign comes back in the y-axis. Does anyone knows what I can do to let the object show positive values no matter what static step he takes?

Thanks in advance.

Vincent

Here are 2 screenshots to visualize my problem

Positive y-axis (static step 1):

Example.png

Negative value (the object adjusted his step to 5):

Example2.png

1 Solution

Accepted Solutions
whiteline
Master II
Master II

It not works only if the object adjusts static step.

Consider writing your dynamic expression for static step so that the axis labels won't reajust automaticaly.

PS: nice feature.

View solution in original post

5 Replies
Not applicable
Author

why don't you use fabs() function ?

Not applicable
Author

I want my y-axis to go from 0 at the top to X (positive number) at the bottom.

Not applicable
Author

post sample file please:)

whiteline
Master II
Master II

It not works only if the object adjusts static step.

Consider writing your dynamic expression for static step so that the axis labels won't reajust automaticaly.

PS: nice feature.

View solution in original post

Not applicable
Author

Thanks this works. I now got positive numbers for all possible steps (when changing my selections), by using a max between my first and second expression and deviding it by 10.