The syntax of the expression is correct?

[Mattia]

Hi guys,

the syntax of the following expression in the script seems correct or no?

If(ApplyMap('KEY_TO_DISCIPLINA',[@10:17],'n/a')='35','ODONTO',
If([@4:9]='001880','DIALISI',
If(Match(ApplyMap('KEY_TO_NOTA',ApplyMap('DOUBLE_MAPPING',[@10:17],'n/a')),'IHca','MIHca'),'BOCA',
If(WildMatch(ApplyMap('KEY_TO_BS_STS21',ApplyMap('DOUBLE_MAPPING',[@10:17],'n/a')),'008'), If([@4:9]=030357,'PS_RADIO','RADIO'),
If(WildMatch(ApplyMap('KEY_TO_BS_STS21',ApplyMap('DOUBLE_MAPPING',[@10:17],'n/a')),'011'), If([@4:9]=030357,'PS_LAB','LAB'),
If(WildMatch(ApplyMap('KEY_TO_NOTA',ApplyMap('DOUBLE_MAPPING',[@10:17],'n/a')),'Ihmac'),'MAC',
If(Len(Trim([@10:17]))>0, If([@4:9]=030357,'PS_AMB','AMB')))))))) as TIPO

I ask this question because the sw don't show me some values (e.g. "PS_LAB", "PS_RADIO") and i don't know why.

In this records, the sw show me PS_AMB instead e.g. PS_LAB

Attached is a sample data file where the expression is the same (or no)?

Please, someone can help me?

Thanks,

Mattia

[Arthur_Fong]

ps: There is no attachment placed.

[Mattia]

Hi Arthur,

please, see this open thread with all the sources: 

 https://community.qlik.com/t5/QlikView-Scripting/Can-someone-help-me-with-this-expression/td-p/16406...

Thanks,

Mattia