topic If statement in inout box custom constraint in QlikView

If statement in inout box custom constraint

zagzebski — Fri, 02 Sep 2016 14:28:08 GMT

I am trying to write an if statement in my custom constraint in an input box. Currently I have the following which works fine :

=$ >vPLR

But I need to write something like the following:

=If(vUser=2,vPLR,$ >vPLR)

I realize the above is not the correct syntax but looking for help if it is possible to write an if statement in a constraint and how it would look.

Thanks,

Steve

Re: If statement in inout box custom constraint

Nicole-Smith — Fri, 02 Sep 2016 19:12:03 GMT

Maybe it would work if you had another variable (e.g. vConstraint) that does the "=If(vUser=2,vPLR,$ >vPLR)" calculation and then just use the variable in the constraint setting? This way you're not actually doing the if calculation in the constraint setting but passing in the actual values that have already been calculated in the variable.

Re: If statement in inout box custom constraint

zagzebski — Fri, 02 Sep 2016 20:13:35 GMT

Thanks Nicole. Makes perfect sense.