How to implement in expression ?

[suvechha_b]

How to write the condition :

If negative value then Sum(projected_adjustment)

If positive value the 0

RISK = Sum(projected_adjustment) is an expression in qlikview model

[simondachstr]

I would suggest using set analysis

sum({<projected_adjustment={'<0'}>} projected_adjustment)

[#3]

Hi

sum({<projected_adjustment={">0"}>} projected_adjustment)

This will return only Neg values.

sum({<projected_adjustment={"<0"}>} projected_adjustment)

This will return only Pos values.

[simondachstr]

It's actually the other way around.. and don't use " but ', because otherwise it will compare the string "<0" rather than the numeric range <0.

[suvechha_b]

Can you please do the calculation with the following expression :

=$(vRisks)-$(vUnit)

Thanks in Advance

[jonathandienst]

Hi

To avoid calculating the expression twice, use RangeMin, like this:

RangeMin(0, Sum(projected_adjustment))

This will return 0 for positive numbers and the value for negative values.

Regards

Jonathan

[jonathandienst · Accepted solution]

As before:

RangeMin(0, $(vRisks)-$(vUnit))

Regards

Jonathan