Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to give two executable statements in the else part. Something like in C++ we can give all the statements to be executed if false can be given inside {} ?
Yes, it can be done in the "Data load editor", something like:
If (a=b) then
...
else
...
end if
In C++ we can call arrays like {Name1, Name2, …} Where as in Qlik we call it as
If(Match(FieldName, 'Name1', 'Name2', …), FieldName) as FiledName1
Or
If(WildMatchMatch(FieldName, 'Name1', 'Name2', …), FieldName) as FiledName1
Note: Find out the diff. of Match & WildMatch