topic Re: Need help with a nested if statement for a Dimension in QlikView

Need help with a nested if statement for a Dimension

Wed, 20 Aug 2014 14:02:14 GMT

Actually, this is for a straight table, and not sure if it should be a dimension or an expression, but I guess I can figure that out on my own. What I can't figure out, is how to create an if statement to populate a value for in the (Result) column.

The columns I am evaluating are:

Flag

Excess

Allowance

Fees

And the logic I am trying to implement goes like this:

IF Flag = 'x'

THEN Excess = Allowance

IF Flag = ''

IF Allowance > Fees THEN Allowance - Fees

IF Allowance < Fees THEN 0

Many thanks!

Re: Need help with a nested if statement for a Dimension

Wed, 20 Aug 2014 14:12:07 GMT

David,

Try this

Excess = if(flag='X',Allowance,if(Allowance > Fees,Allowance-Fees,if(Allowance<Fees,0)))

-Ram

Re: Need help with a nested if statement for a Dimension

Wed, 20 Aug 2014 14:41:22 GMT

Damn... you make it look so easy with so little code...

Many thanks!!