if condition with or not working

Thu, 14 Jun 2012 04:29:13 GMT

Hi All,

I have this condition which is not working.

if(wildmatch(Country,'United States of America','China','Taiwan','Germany (Federal Republic of)', 'Netherlands')>0 AND match(Status,'Allowed','Granted')

and (InventionValue<3 or Tag LIKE '*Apple_Tabled*' or (Company='Apple' and match(IFSCORE,'1','2'))), 'Tabled',

'N/A')

I am asusming that this OR condition could be a problem. Can anyone please tell me how to resolve this type of if or statement issues?

Thank you. I would really appreciate your reply.

Re: if condition with or not working

lironbaram — Thu, 14 Jun 2012 06:30:39 GMT

try this one

if(wildmatch(Country,'United States of America','China','Taiwan','Germany (Federal Republic of)', 'Netherlands')>0 AND match(Status,'Allowed','Granted')>0

and (InventionValue<3 or wildmatch(Tag , '*Apple_Tabled*')>0 or (Company='Apple' and match(IFSCORE,'1','2')>0)), 'Tabled',

'N/A')

topic Re: if condition with or not working in QlikView

if condition with or not working

Re: if condition with or not working