topic Re: What's wrong in this script? in QlikView

What's wrong in this script?

Mattia — Sat, 16 Nov 2024 02:07:36 GMT

Hi Everyone,

the following expression give me only 1 result "AMB", while don't show me "LAB".

If([@4:9]=001880,'DIALISI', If(WildMatch([@10:17],'L*'),'LAB', If(Len(Trim([@10:17]>0)), If([@4:9]=030357,'PS_AMB','AMB')))) as TIPO

Please, someone can help me?

Thanks,

Mattia

Re: What's wrong in this script?

sunny_talwar — Thu, 24 Oct 2019 11:08:43 GMT

May be try this

If([@4:9] = '001880', 'DIALISI', If(WildMatch([@10:17], 'L*'), 'LAB', If(Len(Trim([@10:17]))>0, If([@4:9] = '030357', 'PS_AMB', 'AMB')))) as TIPO

Re: What's wrong in this script?

Mattia — Thu, 24 Oct 2019 12:30:49 GMT

Hi Sunny,

unfortunately, the script don't run anyway.

Do you have another suggest?

Thank you so much,

Mattia

Re: What's wrong in this script?

sunny_talwar — Thu, 24 Oct 2019 12:34:50 GMT

What error message do you get when you run this?

Re: What's wrong in this script?

Mattia — Thu, 24 Oct 2019 12:43:55 GMT

Excuse me Sunny, i misspoke.

The script runs but the value of the field "TIPO" is only "AMB", altough i've values in the table that match the expression: If(WildMatch([@10:17],'L*'),'LAB'

If can help you, if i hidd the last expression If(Len(Trim([@10:17]))>0, If([@4:9] = '030357', 'PS_AMB' , 'AMB', the value of the field "TIPO" is LAB.

Re: What's wrong in this script?

sunny_talwar — Thu, 24 Oct 2019 12:53:51 GMT

Not sure why it doesn't work for you... but it seems to work for me... Sample script

Table: LOAD *, If(Field1 = '001880', 'DIALISI', If(WildMatch(Field2, 'L*'), 'LAB', If(Len(Trim(Field2))>0, If(Field1 = '030357', 'PS_AMB', 'AMB')))) as TIPO; LOAD * INLINE [ Field1, Field2 001880, HSKJS 193829, LHDSH 001880, LDFHS 030357, EHFSH 030357, LDHFS 030357, ];

Here Field1 = [@4:9] and Field2 = [@10:17]

and this is what I get

Re: What's wrong in this script?

Mattia — Thu, 24 Oct 2019 13:30:21 GMT

Sorry, Sunny.

It works perfectly.

Mattia