topic Load statement using Case and When in QlikView

Load statement using Case and When

diane_yu — Fri, 13 Mar 2015 17:08:16 GMT

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!

Re: Load statement using Case and When

sunny_talwar — Fri, 13 Mar 2015 17:16:02 GMT

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,

Re: Load statement using Case and When

diane_yu — Fri, 13 Mar 2015 17:55:03 GMT

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.

Re: Load statement using Case and When

sunny_talwar — Fri, 13 Mar 2015 18:03:29 GMT

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,