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

[Brett_Bleess · Accepted solution]

Duplicate post, see https://community.qlik.com/t5/New-to-QlikView/The-syntax-of-the-expression-is-correct/m-p/1639972#M3... for details.

Regards,
Brett