Load statement using Case and When

[diane_yu]

Please Help!

I know  Qlik does not support CASE WHEN statement and I have tried various "IF" statements but no luck so far.

I'm working on Load statement to create a new column and I am using  "IF ... AND" statement.

I have 2 data elements A_Status (Kept, Pending, S-Call, Tel-Con, and Walk-in) and B_Status (Complete, Unresolvable and Warning).  In order to close the record, A_Status should be one of 5 list "AND" one of the list from B_Status.

Case when

    A_status in ('Kept', 'Pending', 'S-Call', 'Tel-Con', 'Walk-in') and B_status in ('Complete', 'Unresolvable', 'Warning') then 1

End

Thank you for your support in advance!

[sunny_talwar · Accepted solution]

Have you tried this?

If(Match(A_status, 'Kept', 'Pending', 'S-Call', 'Tel-Con', 'Walk-in') and Match(B-status, 'Complete', 'Unresolvable', 'Warning'), 1) as ColumnName

HTH

Best,

S

[diane_yu]

Thank you!   That did it.  I tried pick(wildmatch) option but it didn't worked.  What is the difference between match, pick, and wildmatch? I'm sorry but I'm new to Qlick.  Can you use pipe(|) instead of comma when you listing items?

Thanks.

[sunny_talwar]

I have never tried it with the pipe (and I doubt it would work), but you can give it a try.

From QlikView Help (F1) these are definition with examples for Pick, Match, WildMatch, MixMatch

HTH

Best,

S