topic Re: How to implement in expression ? in QlikView

How to implement in expression ?

suvechha_b — Tue, 10 Sep 2013 08:40:27 GMT

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 — Tue, 10 Sep 2013 08:48:31 GMT

I would suggest using set analysis

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

Tue, 10 Sep 2013 08:55:42 GMT

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 — Tue, 10 Sep 2013 08:57:35 GMT

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 — Tue, 10 Sep 2013 09:00:37 GMT

Can you please do the calculation with the following expression :

=$(vRisks)-$(vUnit)

Thanks in Advance

jonathandienst — Tue, 10 Sep 2013 09:10:55 GMT

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 — Tue, 10 Sep 2013 09:11:43 GMT

As before:

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

Regards

Jonathan