topic Re: If Condition in QlikView

If Condition

Wed, 03 Sep 2014 12:46:33 GMT

Hi QV,

Will this If condition is fine?Every time it was returing "Others" only.

[Product Owner] -it was renamed from source field. So do we need to use source field in If cond??I have tried that too but not resolved.

IF([Product Owner] ='AR2' or 'E04' or 'E06' or 'E08' or 'N01' or 'N05' or 'N06' or 'N08' or 'N09','PC',
IF([Product Owner] ='AR5' or 'AR6' or 'EU1' or 'EU2','CP',
IF([Product Owner] ='E01' or 'E02' or 'E03' or 'E05' or 'E07' or 'E09','ServiceLA','Others'))) as [Business Segment],

Re: If Condition

MK_QSL — Wed, 03 Sep 2014 12:49:49 GMT

IF([Product Owner] ='AR2' or [Product Owner] ='E04' or [Product Owner] ='E06' or [Product Owner] ='E08' or [Product Owner] ='N01' or [Product Owner] ='N05' or [Product Owner] ='N06' or [Product Owner] ='N08' or [Product Owner] ='N09','PC',
IF([Product Owner] ='AR5' or [Product Owner] ='AR6' or [Product Owner] ='EU1' or [Product Owner] ='EU2','CP',
IF([Product Owner] ='E01' or [Product Owner] ='E02' or [Product Owner] ='E03' or [Product Owner] ='E05' or [Product Owner] ='E07' or 'E09','ServiceLA','Others'))) as [Business Segment],

Re: If Condition

vijay_iitkgp — Wed, 03 Sep 2014 12:56:17 GMT

You can simplify by using match/ Wildmatch function

IF( Wildmatch([Product Owner] ,'AR2' , 'E04' , 'E06' , 'E08' , 'N01' 'N05' ,'N06' , 'N08' , 'N09'),'PC',
IF(Wildmatch([Product Owner] ,'AR5' , 'AR6' , 'EU1' , 'EU2'),'CP',
IF(Wildmatch([Product Owner] ,'E01' , 'E02' , 'E03' , 'E05' , 'E07' , 'E09'),'ServiceLA','Others'))) as [Business Segment],

Re: If Condition

Wed, 03 Sep 2014 13:05:51 GMT

Thanks Manish for your quick response but still have some issue

Field not found - <Product Owner>

[Product Owner] -it was renamed from source field. So do we need to use source field in If cond??

Thanks

Re: If Condition

MK_QSL — Wed, 03 Sep 2014 13:10:47 GMT

Provide your original script.... if you have

[YourOldFieldName] as [Product Owner]

in the same table load you need to replace [Product Owner] from my given code with [YourOldFieldName]

IF([Product Owner] ='AR2' or [Product Owner] ='E04' or [Product Owner] ='E06' or [Product Owner] ='E08' or [Product Owner]='N01' or [Product Owner] ='N05' or [Product Owner] ='N06' or [Product Owner] ='N08' or [Product Owner] ='N09','PC',
IF([Product Owner] ='AR5' or [Product Owner] ='AR6' or [Product Owner] ='EU1' or [Product Owner] ='EU2','CP',
IF([Product Owner] ='E01' or [Product Owner] ='E02' or [Product Owner] ='E03' or [Product Owner] ='E05' or [Product Owner]='E07' or 'E09','ServiceLA','Others'))) as [Business Segment],

So in above code Replace [Product Owner] with [YourOldFieldName]

Re: If Condition

Wed, 03 Sep 2014 13:50:48 GMT

yes i have repleced and tried that too but not resolved.

here is Product Owner script.

TextBetween([Product Owner - Product Owner Level 01 (Key)] , '[' , ']',2) as [Product Owner],

Thanks

Re: If Condition

MK_QSL — Wed, 03 Sep 2014 13:55:42 GMT

Load Something Like below

Load

IF([Product Owner] ='AR2' or [Product Owner] ='E04' or [Product Owner] ='E06' or [Product Owner] ='E08' or [Product Owner]='N01' or [Product Owner] ='N05' or [Product Owner] ='N06' or [Product Owner] ='N08' or [Product Owner] ='N09','PC',
IF([Product Owner] ='AR5' or [Product Owner] ='AR6' or [Product Owner] ='EU1' or [Product Owner] ='EU2','CP',
IF([Product Owner] ='E01' or [Product Owner] ='E02' or [Product Owner] ='E03' or [Product Owner] ='E05' or [Product Owner]='E07'or 'E09','ServiceLA','Others'))) as [Business Segment];

Load

TextBetween([Product Owner - Product Owner Level 01 (Key)] , '[' , ']',2) as [Product Owner],

...

From tablename;

Re: If Condition

Wed, 03 Sep 2014 14:20:52 GMT

Thanku Manish