topic Re: PLEASE HELP ME WITH THIS CASE STATEMENT. in QlikView

PLEASE HELP ME WITH THIS CASE STATEMENT.

Tue, 17 Dec 2013 15:04:31 GMT

CASE WHEN ITEM_ID LIKE '%CB%' THEN SUBSTR(ACCOUNT_NO,4,10)

WHEN ITEM_ID LIKE 'D%' THEN SUBSTR(ACCOUNT_NO,5,8)

ELSE ACCOUNT_NO END AS InSite_Acct,

I am trying like this below.It is giving me error.Can anybody tell me what am I doing wrong here?

if(WildMatch([ITEM ID],'*CB*',mid([Account Number],4,10)

if(WildMatch([ITEM ID],'*D*',mid([Account Number],5,8),([Account Number])) as INsite_Acct,

Re: PLEASE HELP ME WITH THIS CASE STATEMENT.

Nicole-Smith — Tue, 17 Dec 2013 15:17:44 GMT

if(WildMatch([ITEM ID],'*CB*'),mid([Account Number],4,10),

if(WildMatch([ITEM ID],'*D*'),mid([Account Number],5,8),[Account Number])) as INsite_Acct,

Re: PLEASE HELP ME WITH THIS CASE STATEMENT.

Peter_Cammaert — Tue, 17 Dec 2013 15:18:27 GMT

Various things are wrong. In LOAD statements, QlikView has this annoying IF syntax because an IF really is a function with two or three parameters. Check the nesting of the two IFs. It should be more like:

IF (wildmatch(), result1,

IF (wildmatch(), result2,

result3)) AS Fieldname ...

Count the comma's and the parentheses.

Luck,

Peter

Re: PLEASE HELP ME WITH THIS CASE STATEMENT.

Tue, 17 Dec 2013 17:57:46 GMT

Thank you very much.