Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Mattia
Creator II
Creator II

Applymap error, script don't work

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

Labels (2)
2 Replies
tresB
Champion III
Champion III

It looks to be equivalent to :

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

Mattia
Creator II
Creator II
Author

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

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

Mattia