How can i correct this expression in the script?

Mattia — Sat, 16 Nov 2024 02:08:45 GMT

Hi QV users,

i've a problem with the following expressions in the script:

KEY_TO_CODICE_PRESTAZIONE:
Mapping LOAD
[@10:17] as CONTATORE_PRESCRIZIONE,
[@29:33] as CODICE_PRESTAZIONE

1) If([@276:276]='S', If(ApplyMap('KEY_TO_CODICE_PRESTAZIONE',[@10:17],'n/a')='87371','SCREENING','BDG') as new field

it works perfectly: if the field [@276:276] contains the letter "S" and the field [@29:33] contains the value "87371", the new field show me "SCREENING", otherwise "BDG" (if the field [@29:33] not contains the value "87371").

2) If([@276:276]='S', If(ApplyMap('KEY_TO_CODICE_PRESTAZIONE',[@10:17],'n/a')='87371'or'87372','SCREENING','BDG') as new field

don't work: my real goal is that if the field [@276:276] contains the letter "S" and the field [@29:33] contains the value "87371" or the value "87372", the new field must show me "SCREENING", otherwise "BDG" (if the field [@29:33] not contains the value "87371" or the value "87372").

Please, can someone show me the right direction?

Thanks,

Mattia

Re: How can i correct this expression in the script?

Vegar — Wed, 23 Oct 2019 10:15:30 GMT

Try

If( [@276:276]='S', If( match( ApplyMap('KEY_TO_CODICE_PRESTAZIONE',[@10:17],'n/a'), '87371','87372' ), 'SCREENING', 'BDG' ) as [New field]

Re: How can i correct this expression in the script?

Mattia — Wed, 23 Oct 2019 10:28:41 GMT

Many thanks, Vegar!

Your solution runs perfectly!

Mattia

topic Re: How can i correct this expression in the script? in QlikView

How can i correct this expression in the script?

Re: How can i correct this expression in the script?

Re: How can i correct this expression in the script?