topic ApplyMap not working in QlikView

ApplyMap not working

Karl_Hart — Fri, 11 Jul 2014 10:21:07 GMT

I can't understand why the following map isn't working. The mapping table has the right data, and the destination table creates the correct field, but it has null values. Any ideas?

DisablityMap:

Mapping Load "adisabil_cde",

"adisabil_dsc" ;

SQL SELECT *

FROM PUB."mis_adisabil";

Disability: LOAD "per_num",

"adisabil_cde",

ApplyMap('DisabilityMap', adisabil_cde, 'NONE') as [Person Disability],

"aperdisabil_str_dat" as [Person Disability Start Date],

"aperdisabil_end_dat" as [Person Disability End Date],

"TimeStamp"

where "aperdisabil_end_dat" > $(vToday) or len ("aperdisabil_end_dat") = 0;

SQL SELECT *

FROM PUB."mis_aperdisabil";

STORE Disability into 10_QVDFiles\Disability.qvd;

Many thanks

Re: ApplyMap not working

ali_hijazi — Fri, 11 Jul 2014 10:23:43 GMT

remove the double quotation marks around the field names

i think this is the only reason

make sure too that aperdisabil_end_dat" and $(vToday) have the same format and I think you should use '$(vToday)'

Re: ApplyMap not working

tresB — Fri, 11 Jul 2014 10:31:22 GMT

Perhaps the field is not being recognized without quotes. Put proper quotes and try like:

ApplyMap('DisabilityMap', "adisabil_cde", 'NONE') as [Person Disability],

Re: ApplyMap not working

Karl_Hart — Fri, 11 Jul 2014 10:55:26 GMT

Thanks for the heads up about the $9vToday), I'll look into it.

However, changing the quotation marks around the field name didn't affect the outcome of my initial query.

Thanks

Re: ApplyMap not working

Karl_Hart — Fri, 11 Jul 2014 10:56:05 GMT

Thanks for the suggestion but it still gives the same result with the changes you suggested.

Re: ApplyMap not working

Anonymous — Fri, 11 Jul 2014 11:32:02 GMT

You have a typo in the Mapping table name: DisablityMap. Should be DisabilityMap.

Greatings.

Nicolai

Re: ApplyMap not working

Karl_Hart — Fri, 11 Jul 2014 11:44:04 GMT

Thanks, I'm sure I checked that a million times but words were never my strong point.

Thanks.