Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Make 0 (zero) when value is negative

Hi,

I'm looking for a clean formually which turns any value to 0 when the original value goes below 0.

I'm having a dashboard based on a log, and I need to do calculations in the front end (unfortunately) to come to a certain number. Sometimes, when selecting certain dimensions, I'm getting negative values which make sense according to the formula, but can't occur in the real world (eg: -3 registrations).


I could of course work with an if like this:

if(value <= 0, 0, value)

... but I wanted to know if their might be a cleaner way to do this as my "value" in the script above is actually a pretty large formula)

Kind regards,

Christophe

Ps: The value is shown in a text object in my dashboard

Tags (4)
1 Solution

Accepted Solutions
Highlighted

Re: Make 0 (zero) when value is negative

Hi

Try like this

I think this will helps you,

Rangemax(Value,0)

View solution in original post

3 Replies
Highlighted
Specialist III
Specialist III

Re: Make 0 (zero) when value is negative

Hi Christophe,

how about max(0, value)?

Marcus

Highlighted

Re: Make 0 (zero) when value is negative

Hi

Try like this

I think this will helps you,

Rangemax(Value,0)

View solution in original post

Highlighted
Creator
Creator

Re: Make 0 (zero) when value is negative

Wow, thanks for the fast reponses !!

Rangemax did the trick.. !