topic Re: Applymap error, script don't work in QlikView

Applymap error, script don't work

Mattia — Sat, 16 Nov 2024 02:07:40 GMT

Hi guys,

another problem with the applymap function. i've the following script, but it don't work:

KEY_TO_UO_RIFERIMENTO:
Mapping LOAD
[@10:17] as CONTATORE_PRESCRIZIONE,
[@29:33] as UO_RIFERIMENTO

If(ApplyMap('KEY_TO_UO_RIFERIMENTO',[@10:17],'n/a')=35,'ODONTO') as TIPO

The output i want is this: when the field [@29:33] =35, the new field TIPO must show "ODONTO".

What's wrong?

Thanks,

Mattia

tresB — Thu, 24 Oct 2019 09:34:41 GMT

It looks to be equivalent to :

If([@29:33]=35,'ODONTO') as TIPO

Mattia — Thu, 24 Oct 2019 09:41:30 GMT

Yes, but the field [@29:33] is in another table/source.

If i insert this expression in the script, don't work.

Mattia