Is there something wrong in this script?

Mattia — Sat, 16 Nov 2024 19:41:32 GMT

Hi guys,

i need your help because the following script don't work.

DOUBLE_MAPPING:
Mapping LOAD
[@57:64] as CONTATORE_PRESCRIZIONE,
[@51:56] as COMUNE_RESIDENZA_AMB1

KEY_TO_ASL_LOMBARDA:
Mapping LOAD
Codice as COMUNE_RESIDENZA_AMB1,
ASL_lombarda

If(WildMatch(ApplyMap('DOUBLE_MAPPING',ApplyMap('KEY_TO_ASL_LOMBARDA','n/a',[@57:64])),'3*'),ApplyMap('DOUBLE_MAPPING',ApplyMap('KEY_TO_ASL_LOMBARDA','n/a',[@57:64]))

The output i want is: if the field ASL_Lombarda begin with 3, i want to see the value of field ASL_Lombarda.

Please, someone can help me?

Thanks,

Mattia

Re: Is there something wrong in this script?

Brett_Bleess — Mon, 18 Nov 2019 14:29:58 GMT

Mattia, in cases like this, it is likely going to be very helpful if you attach QVW file, so other folks can see the data model and how you are trying to use things in order to have a better idea of what you need... If you do have confidential field info in the app, you can use the Scrambling tab of the Settings\Document Properties in the Desktop Client to scramble those values before posting...

Regards,
Brett

topic Re: Is there something wrong in this script? in QlikView

Is there something wrong in this script?

Re: Is there something wrong in this script?