topic Re: Newbe Question to applymap() in QlikView

Newbe Question to applymap()

cosmicyes — Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 25 Jul 2017 14:02:39 GMT

This doesn't work?

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

effinty2112 — Tue, 25 Jul 2017 14:09:13 GMT

Hi Rainer,

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

Cheers

Andrew

cosmicyes — Wed, 26 Jul 2017 05:32:17 GMT

Thank you both.

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

shiveshsingh — Wed, 26 Jul 2017 06:43:21 GMT

small error

try with Bezeichnung, not INAUSEG in applymap