topic Re: applymap in QlikView

applymap

Tue, 03 Feb 2015 07:05:27 GMT

i have ritten

map2:

mapping load * inline [
x,y
usa,us
u.s.a,us
americ,us
];

in expression:

ApplyMap

('map2','americ','not')

can any 1 tell y its not wrkng

Tue, 03 Feb 2015 07:10:19 GMT

dont write apply map in expression

u have to write in another table

Colin-Albert — Tue, 03 Feb 2015 07:56:10 GMT

Applymap is used in the load script when loading data into a table.

Applymap cannot be used in charts or front-end expressions as all mapping tables are deleted when the load finishes.

You need to use Appymap('map2', yourdatafield, 'now') as country

Tue, 03 Feb 2015 08:43:24 GMT

even when i do this, it is showing error:

map2:

mapping load * inline [
x,y
usa,us
u.s.a,us
americ,us
];
gt:
LOAD ApplyMap('map2','usa','not found') as country Resident map2;

Colin-Albert — Tue, 03 Feb 2015 11:45:15 GMT

You cannot use the mapping table (map2) as the source for the gt data, you need to load the data from a different source.

The applymap expression needs to reference a field not an explicit text value 'usa' .

gt:

LOAD ApplyMap('map2', yourfieldname,'not found') as country from anotherdatatable;