Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
This doesn't work?
ApplyMap ('INAUSEG_Mapping',[INAUSEG],'N/A') as [Bezeichnung],
Hi Rainer,
Check that the listbox is for the field Bezeichnung and not INAUSEG.
Cheers
Andrew
Thank you both.
Of course that was my main mistake to choose INAUSEG instead of Bezeichnung in the listbox 🙂
small error
try with Bezeichnung, not INAUSEG in applymap