topic Re: Apply Map in QlikView

Apply Map

upaliwije — Tue, 30 Sep 2014 08:36:55 GMT

Hi friends

I have following script in respect of apply map command

Mapsalvage:

Mapping Load CLAIM_N0, SALVAGE From e:\SALVAGE.qvd

(qvd) ;

ALL:

Load *,

ApplyMap(' Mapsalvage',CLAIM_NO, null()) as SALVAGE

Resident MC;

DROP TABLE MC;

This script runs well but no data is returned for the field SALVAGE. Salvage is a numeric value. Is it not possible to add a numeric value in apply map. If so what should I do

Re: Apply Map

ashfaq_haseeb — Tue, 30 Sep 2014 08:40:20 GMT

Hi, do you have CLAIM_NO filed in ALL table which you loaded from Resident MC;

Regards

ASHFAQ

Re: Apply Map

sushil353 — Tue, 30 Sep 2014 08:43:49 GMT

Hi ,

Try below one:

ApplyMap(' Mapsalvage',CLAIM_NO,' ') as SALVAGE

HTH

Sushil

Re: Apply Map

upaliwije — Tue, 30 Sep 2014 08:43:52 GMT

Yes

Re: Apply Map

martinpohl — Tue, 30 Sep 2014 08:46:03 GMT

Is this the original script?

One you wrote Claim_N0, twice Claim_NO (the first one is a 0 (null), the second an O (o).

At the applymap there is a blank bewteen ' and the table name.

For test write 'test' instead of null at the apply-line.

If the field i sfilled with 'test' the compared field (Claim_NO) is an matching.

If there are no values the applytable is not found.

Unfortunately there is no error message on this.

Regards.

Re: Apply Map

ashfaq_haseeb — Tue, 30 Sep 2014 08:47:19 GMT

Hi,

If somehow you rename

CLAIM_NO as Sometext in your MC Table

Then use as below

ApplyMap('Mapsalvage',Sometext, null()) as SALVAGE

Remove space before ' Mapsalvage'

Let me know if that worked

Regards

ASHFAQ

Re: Apply Map

jonathandienst — Tue, 30 Sep 2014 08:52:00 GMT

Firstly, you need to remove the leading space in the map name:

ApplyMap(' Mapsalvage',... should be ApplyMap('Mapsalvage',...

That may solve the problem. If not, check that the values of CLAIM_NO in Salvage.qvd and the resident table intersect. You have assigned null as the default so if the resident value is not found in the map, ApplyMap will return a null. Pay attention to the fomatting of the values in the two sources.

HTH

Jonathan

Re: Apply Map

upaliwije — Tue, 30 Sep 2014 09:32:17 GMT

Thanks all