apply map

upaliwije — Thu, 20 Sep 2018 08:11:02 GMT

Hi Friends

I have written following script in my data load

But it does give any results for 2nd apply map condition. Have I made any error . Pls help me to get it correct

Re: apply map

Peter_Cammaert — Thu, 20 Sep 2018 08:49:46 GMT

Your logic is wrong. I'd like to add some spaces to your statement:but you posted a screenshot and that's difficult to edit...

The second ApplyMap() call is only executed when CRE_TYPE='2', but this test is embedded as third parameter in the first ApplyMap() call that is only executed when CRE_TYPE='1'. The third parameter of an ApplyMap() call is only executed if the second parameter cannot be found in the Mapping Table as specified by the first parameter.

CRE_TYPE cannot have two values at the same time.

I guess you better write someting like:

IF (CRE_TYPE='1', ApplyMap('map1C', ..., Null()),

IF (CRE_TYPE='2', ApplyMap('map2C', ..., Null()))) AS CP_RATE

Re: apply map

upaliwije — Fri, 21 Sep 2018 03:14:53 GMT

Thanks a lot

topic apply map in QlikView

apply map

Re: apply map

Re: apply map