topic Re: apply map is not working in QlikView

apply map is not working

Mon, 26 Jan 2026 18:19:17 GMT

Team

I have created the following map.

map1:

mapping load * inline [

x, y

1, one

2, two

3, three ] ;

and used in the text box as

=ApplyMap ('map1', 2)

I could not able to get the output as two. Is this apply map should work in all the Version of QLIKview...

Re: apply map is not working

sunny_talwar — Thu, 31 Mar 2016 10:15:17 GMT

ApplyMap() is only a back-end (or script) function. You cannot use ApplyMap() in front end objects such as text boxes and charts

Re: apply map is not working

Chanty4u — Thu, 31 Mar 2016 10:51:05 GMT

As sunny said. It is not possible to use in frontend.

Mapping and ApplyMap Examples

Re: apply map is not working

Kushal_Chawda — Thu, 31 Mar 2016 10:56:21 GMT

You can use Applymap() only in script, you can't use it on front end.

what you are trying to achieve? What is requirement?

Re: apply map is not working

swuehl — Thu, 31 Mar 2016 10:58:14 GMT

You can try something like

//No Mapping LOAD

load * inline [
x, y
1, one
2, two
3, three ] ;

and used in the text box as

=Only({<x = {2}>} y)

Re: apply map is not working

imrencimen — Thu, 31 Mar 2016 11:23:54 GMT

if u want to use applymap u need two table. first one is has two fields and matched field write first.

map1:

mapping load * inline [
x, y
1, one
2, two
3, three ] ;

Map2:

Load

Applymap('map1',x,'NULL')

field3,

field4

FROM

Map2.xlsx (ooxml, embedded labels, table is Gorevler);

Re: apply map is not working

settu_periasamy — Thu, 31 Mar 2016 12:08:36 GMT

I think , you tried with Qlikview Help file example..

Just try the below code..

map1:
mapping load * inline [
x, y
1, one
2, two
3, three ] ;

T1:
LOAD ApplyMap ('map1', 2 ) as Field1, // returns ' two'
     ApplyMap ('map1', 4 ) as Field2, //returns 4
     ApplyMap ('map1', 5, 'xxx') as Field3, //returns 'xxx'
     ApplyMap ('map1', 1, 'xxx') as Field4, // returns 'one'
     ApplyMap ('map1', 5, null( ) ) as Field5, // returns NULL
     ApplyMap ('map1', 3, null( ) ) as Field6 // returns 'three'
Inline [ Temp
''];

Re: apply map is not working

Peter_Cammaert — Thu, 31 Mar 2016 12:53:06 GMT

Apparently, you can use Applymap() in UI objects. The function name is accepted but always returns NULL, even if you supply a third parameter. Which IMHO means that the function isn't even executed, or skips execution on entry.

And in any case, this wouldn't work at all as one of the main properties of mapping tables is that they are dropped at the end of reload scirpt execution. Mapping tables do not survive a reload. Ever.

And based on public knowledge of QlikView settings and options, there is nothing that can be done about this behaviour. Even the easter eggs do not list an option that hints at manipulating mapping table behavior. Sorry.

Re: apply map is not working

ysj — Fri, 19 Jan 2018 11:25:39 GMT

As sunny said. It is not possible to use in frontend.

ApplyMap() is only a back-end (or script) function. You cannot use ApplyMap() in front end objects such as text boxes and charts

apply map is not working

Re: apply map is not working

VishalWaghole — Fri, 19 Jan 2018 12:30:54 GMT

As sunny said applymap is back end function.

Please have look on it Apply Map Concept

This will make you clear apply map concept.

Thanks,

Vishal