Newbe Question to applymap()

[cosmicyes]

I am quite new to QlikView and am assigned to maintain an existing QlikView cockpit.

I tried to map a Value named INAUSEG which can contain either I, A or E to more speaking values.

The mapping table is in a separate Tab called "mapping" and is:

INAUSEG_Mapping:

MAPPING

LOAD * INLINE [

     Kuerzel, Bezeichnung

     A, Ausland

     E, EG

     I, Inland

];

I tried the following code in applymap:

applymap ('INAUSEG_Mapping',[KUERZEL],'N/A') as [Bezeichnung],

but when running the script I get the error "Field not found <KUERZEL>"

When in applymap I change [KUERZEL] to INAUSEG the script runs well but with no effect - in the listbox there is still only E, A and I.

Any hints are very appreciated.

[sunny_talwar]

This doesn't work?

ApplyMap ('INAUSEG_Mapping',[INAUSEG],'N/A') as [Bezeichnung],

[effinty2112]

Hi Rainer,

Check that the listbox is for the field Bezeichnung and not INAUSEG.

Cheers

Andrew

[cosmicyes]

Thank you both.

Of course that was my main mistake to choose INAUSEG instead of Bezeichnung in the listbox 🙂

[shiveshsingh]

small error

try with Bezeichnung, not INAUSEG in applymap