topic Re: Please help me with the below if statement. in QlikView

Please help me with the below if statement.

Fri, 20 Sep 2013 11:51:09 GMT

Am I doing anything wrong here?

if([Product Categeory Desc]='Non Managed NFS',

if([Product Categeory Desc]='Non NFS Accounts'),[Product Categeory Desc]) as NonReccuring,

Thanks, in advance.

Re: Please help me with the below if statement.

tresB — Fri, 20 Sep 2013 11:58:25 GMT

Should be something like:

if( [Product Categeory Desc]='Non Managed NFS', 'SomeThing' ,

if([Product Categeory Desc]='Non NFS Accounts' ,[Product Categeory Desc]) ) as NonReccuring,

Note: changes are in RED (one brace has been moved to the end)

Re: Please help me with the below if statement.

abeyphilip — Fri, 20 Sep 2013 12:01:15 GMT

Hi,

Not sure of the requirement here, but there is a problem in the syntax, you are missing one parameter in your second "if" statement.

if([Product Categeory Desc]='Non Managed NFS',

if([Product Categeory Desc]='Non NFS Accounts',Match_Result),[Product Categeory Desc]) as NonReccuring

Regards,
Abey

Re: Please help me with the below if statement.

Fri, 20 Sep 2013 12:16:33 GMT

Thank you.It worked.

Re: Please help me with the below if statement.

Fri, 20 Sep 2013 12:18:34 GMT

try this

if([Product Categeory Desc]='Non Managed NFS',

if([Product Categeory Desc]='Non NFS Accounts',[Product Categeory Desc]) ) as NonReccuring,