Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers,
I'm wondering if it il possible to use IF, THEN, ELSE in LOAD.
This is what I’m trying to do:
LOAD
if "Test" = 'empty' then
if "Test2" = 'empty' then
'Empty'
Else
'New'
End if
Else
'OLD'
End if AS "Test3"
FROM ...
Is there something wrong with my syntax, or the only possible way iln LOAD is to do
LOAD
If("Test"= 'empty', if (“Test2”=’empty’, ’empty’,’New’),’OLD’) as "Test3"
FROM ...
Thanks for your help
Make sense
Happy to help