topic Re: ApplyMap doesn't use default mapping in QlikView

ApplyMap doesn't use default mapping

gf — Sat, 16 Nov 2024 20:40:19 GMT

Hello all,

My ApplyMap which looks like this:

ApplyMap('T1',LANDISO & BLTSPRISO & BLTGS1,'AT' & 'DEAT' & BLTGS1) as TextG1

doesn't work as expected.

For values where LANDISO and BLTSPRISO and BLTGS1 are in my Mapping table it works fine but if the value isn't in my mapping table, T1 should map on 'AT' & 'DEAT' & BLTGS1 which doesn't work..

Any ideas?

Regards, Gf

Re: ApplyMap doesn't use default mapping

Lisa_P — Fri, 14 Jun 2019 00:34:41 GMT

Can you show your script ?

Re: ApplyMap doesn't use default mapping

Nishanthi — Fri, 14 Jun 2019 05:10:12 GMT

Hi, BLTGSI hope it is a field.... So if none maps in your situations then it goes to this expression,
" 'AT' & 'DEAT' & BLTGS1 ". But here if you look at it, it doesn't know internally which value of it to concatenate. For example , BLTGS1 contains A1,B2,B4,Y6 then from your expression point of view,
ATDEAT___ which value should be replaced. So try giving any other alternative.

Re: ApplyMap doesn't use default mapping

jonathandienst — Fri, 14 Jun 2019 05:24:52 GMT

>>but if the value isn't in my mapping table, T1 should map on...

I think you may be misunderstanding the third parameter of ApplyMap(). It is simply a value that is returned if there is no match in the mapping table. To map a different value, you could use this:

ApplyMap('T1', LANDISO & BLTSPRISO & BLTGS1, ApplyMap('T1', 'AT' & 'DEAT' & BLTGS1, 'No Match')) as TextG1