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

please help me with the if statement.

Thu, 06 Feb 2014 20:29:01 GMT

How can I put these 2 if statements in 1 if statement.

if(match(CATEGORY,'4','9','16','21','22')=0,'Trust_Non-Reccuring','Trust_Reccuring') as FEETYPE

if(ActualAccount <>0,'Trust Reccuring') as FEETYPE

Thanks in advance.

Thu, 06 Feb 2014 20:33:53 GMT

Like this?

if(match(CATEGORY,'4','9','16','21','22')=0,'Trust_Non-Reccuring',if(ActualAccount <>0,'Trust Reccuring') ) as FEETYPE

rwunderlich — Thu, 06 Feb 2014 20:40:52 GMT

What's the value supposed to be if CATEGORY=4 and ActualAccount=0?

-Rob

maxgro — Thu, 06 Feb 2014 20:42:09 GMT

not fully understand the logic of your inquiry, however you can combine and, or, and nested if, for example,

if(match(CATEGORY,'4','9','16','21','22')=0 or ActualAccount=0, 'Trust_Non-Reccuring',

if(match(CATEGORY,'4','9','16','21','22')=1 or ActualAccount <>0, 'Trust_Reccuring',

'???'))