topic ApplyMap does not return results in QlikView

ApplyMap does not return results

Tue, 15 Sep 2015 11:46:45 GMT

Hi everybody,

I am sure that this should be an easy task but for some reason I have troubles to find my error. I want to use a simple ApplyMap function. My code looks like this:

Pickup_Mapping:

LOAD OUTLET_ID & '-' & PICKUP_ID as OutletPickup,

PickupOutlets.OUTLET_NAME

FROM

[someqvd.qvd]

(qvd);

StateTimes:

LOAD

SomeColumns1,

SomeColumns2,

OUTLET_ID & '-' & PICKUP_ID as OutletPickup,

ApplyMap('Pickup_Mapping', OUTLET_ID & '-' & PICKUP_ID) as OUTLET_NAME

FROM

[someotherqvd.qvd]

(qvd);

My Problem is now, that the result of ApplyMap is null for each row, although there should be a match for almost each row. If I look in my table view, the two tables are connected and have a 100% information density and a 92% subset ratio. If I select PickupOutlets.OUTLET_NAME the right filters apply on the data from other tables.

I do not find the problem in my code and I really appreciate your help on this one.

Cheers,

Claus

Re: ApplyMap does not return results

gautik92 — Tue, 15 Sep 2015 11:48:02 GMT

yu should use mapping keyword na

Pickup_Mapping:

Mapping LOAD OUTLET_ID & '-' & PICKUP_ID as OutletPickup,

PickupOutlets.OUTLET_NAME

FROM

[someqvd.qvd]

(qvd);

Re: ApplyMap does not return results

Clever_Anjos — Tue, 15 Sep 2015 11:50:41 GMT

Pickup_Mapping:

MAPPING LOAD OUTLET_ID & '-' & PICKUP_ID as OutletPickup,

PickupOutlets.OUTLET_NAME

FROM

[someqvd.qvd]

(qvd);

Re: ApplyMap does not return results

Tue, 15 Sep 2015 11:51:51 GMT

Of course,

how could I not see this. Thank you very much.