Creating a new field based on multiple field values

Thu, 11 Jul 2013 18:33:59 GMT

Hi All,

I have a requirement to derive a new filed (during the load process) based on 4 field values.

I tried to create a new field with nested if statements and that looks awful and very hard to maintain it.

So just wondering whether any of you came across the same scenario and found an easy way ?

if (F1 = 'NO_DATA' , NO_DATA' ,

F1 <> 'NO_DATA' and F2 > 0 and F3 > 0 and F4 = 'NO_DATA' , 'Scenario 1'

and so forth

Thanks in advance,

Aji Paul

topic Creating a new field based on multiple field values in QlikView