topic Problem with the If condition in QlikView

Problem with the If condition

Mon, 11 Jun 2012 07:37:47 GMT

Hi All,

I have this if condition, but it's not working for some reason. Can anyone tell me what am I missing here?

Load if((Country = 'United States of America' or Country ='China' or Country ='Taiwan' or Country ='Germany (Federal Republic of)' or Country ='Netherlands') and ( "Status"= 'Allowed' or "Status"='Granted')

and( Company = 'ABC')

and (DFAnalysis = 'Low')

AND (IFSCORE >= 3), 'LOW', 'NA') as Stage, ID

Resident Temp;

Thank you.

Problem with the If condition

Mon, 11 Jun 2012 08:10:09 GMT

Hi,

Please try wildmatch in place of "(Country = 'United States of America' or Country ='China' or Country ='Taiwan' or Country ='Germany (Federal Republic of)' or Country ='Netherlands')

if(wildmatch( Country, 'United States of America' ,'China' ,'Taiwan' ,'Germany (Federal Republic of)','Netherlands') >0

and wildmatch(Status,'Allowed','Granted')>0 .........

Problem with the If condition

jagan — Mon, 11 Jun 2012 08:27:12 GMT

Hi,

Try this

Load IF( Match(Country, 'United States of America', 'China', 'Taiwan', 'Germany (Federal Republic of)', 'Netherlands')

AND Match(Status, 'Allowed' , 'Granted')

AND Company = 'ABC'

AND (DFAnalysis = 'Low'),

IF(SCORE >= 3, 'LOW', 'NA')) as Stage,

Hope this helps you.

Regards,

Jagan.

Problem with the If condition

Mon, 11 Jun 2012 08:44:41 GMT

Hi,

Load if(wildmatch(Country,'United States of America','China','Taiwan','Germany (Federal Republic of)', Country ='Netherlands') >0

and wildmatch(Status= 'Allowed','Granted')> 0

and wildmatch(Company,'ABC') >0 and

wildmatch(DFAnalysis,'Low') >0

AND IFSCORE >= 3, 'LOW', 'NA') as VettingStage,

Resident Temp;

I am getting only one value for VettingStage field which is NA, and this means something is worng in this condition. Can you please check?

Thanks a lot for your reply.

Problem with the If condition

Mon, 11 Jun 2012 09:02:14 GMT

Hi,

Try this.its working fine.

test:
Load * Inline
[ Country,Status,Company,DFAnalysis,IFSCORE
United States of America,Allowed,ABC,Low,5
China,Granted,ABC,Low,8
];

load
if(
                 (wildmatch(Country,'United States of America','China','Taiwan','Germany (Federal Republic of)', 'Netherlands') >0 )
                   and wildmatch(Status, 'Allowed','Granted')> 0
                   and (Company='ABC')
                   and (DFAnalysis='Low')
                   and IFSCORE >= 3,
                  'LOW', 'NA') as test1
resident test;

Problem with the If condition

Mon, 11 Jun 2012 09:13:13 GMT

hi,

Ur condition was failing in line

1) "if(wildmatch(Country,'United States of America','China','Taiwan','Germany (Federal Republic of)', Country ='Netherlands') >0"

observe in this line u have used " Country ='Netherlands' " ,this is wrong syntax, as u have alredy mentioned Country field as first parameter in wildmatch function

2) " wildmatch(Status= 'Allowed','Granted')> 0

and wildmatch(Company,'ABC') >0

beacuse you putted "=" sign after status inplace of "," .

Also we dont need to put wildmatch or match when we have only one value to cample in field, so no need of using wildmatch for "Company" "FAnalysis".

Problem with the If condition

Mon, 11 Jun 2012 15:01:04 GMT

LOAD

if(

(

Country = 'United States of America' or

Country ='China' or

Country ='Taiwan' or

Country ='Germany (Federal Republic of)' or

Country ='Netherlands'

)

AND

(

"Status"= 'Allowed' or "Status"='Granted'

)

AND

(

Company = 'ABC'

)

AND

(

DFAnalysis = 'Low'

)

AND

(

IFSCORE >= 3

)

,'LOW','NA')

MAY be it's run

Problem with the If condition

Mon, 11 Jun 2012 23:28:56 GMT

Hi,

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

and( Company = 'Apple')

and (DFAnalysis = 'Low')

AND (IFSCORE >= 3), 'LOW', 'NA') as VettingStage,

Resident Temp;

I am using this, but its still not working. also, I tried breaking this if statement but, only the country condition in the above is working and no other condition seems to be working fine. I am not sure about the reason, can you please tell me what could be the reasons?

Thanks a lot.

Re: Problem with the If condition

Tue, 12 Jun 2012 04:28:42 GMT

hi,

their is error in ur secound line "wildmatch(Status= 'Allowed','Granted')> 0" that you have written ,

dont write "=" sign after Status it should be "wildmatch(Status, 'Allowed','Granted')> 0".

I mentioned it above also.

Please correct this line.

Re: Problem with the If condition

Tue, 12 Jun 2012 06:06:45 GMT

Hi, I corrected this error, but by mistake I posted it here. Sorry about that. All my conditions worked except these :

Company = 'Apple' and IFSCORE>=3 and NOT Tag LIKE '*Rejected*'

So, when I run my script with the following code it runs fine:

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

and (DFAnalysis = 'Low')

, 'LOW', 'NA') as VettingStage,

Resident Temp;

But, when I am adding the above 3 conditons , I only get output as NA for the Vetting stage field.

I am using the following expression.

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

and Company = 'Apple' and IFSCORE>=3 and NOT Tag LIKE '*Rejected*'

and (DFAnalysis = 'Low')

, 'LOW', 'NA') as VettingStage,

Resident Temp;

Tag is a field name in my data model. I tried running my script, but any of these above conditions are not working, even though I have records that satisfy these conditons.

Thank you. I would really appreciate your response.

Re: Problem with the If condition

Tue, 12 Jun 2012 06:23:59 GMT

hi,

write the last condition as " and Company='Apple'

and IFSCORE >=3

and wildmatch( Tag, '*Rejected*')=0

and DFAnalysis='LOW' "

incooperate this code in if condition,this is working.

else please attach your application so i can work on it.

Pratibha