topic Re: Nested IF: in QlikView

Nested IF:

skompel2 — Sat, 16 Nov 2024 04:36:46 GMT

I keep getting "Error in Expression: ')' expected" when I create new field in script -

If([Location]='SD','up',If(Match([Location], '00', '01', '02', '03', '04', '05', '06'), 'down', If(Match([Location], 'AA', 'AB', 'AC' 'AD', 'AE', 'AF', 'AG', 'AH', 'AI'),'Sub', If(Match([Location], 'BB','BC','BD'), 'Kitty')))) as Status,

.......

"Location" is a column here and I want to create "Status" as a new field. Can anyone point me to the error?

< P.S - post edited to hide info >

Re: Nested IF:

sunny_talwar — Wed, 30 Jan 2019 17:09:21 GMT

The If statement seems to look good... can you share an image of the error message?

If([Proposed Location] = 'SD', 'Exchange',
If(Match([Proposed Location], 'EA00', 'TR00', 'CA00', 'CH00', 'NZ00', 'OP00', 'RA00'), 'Teardown',
If(Match([Proposed Location], 'CH00FL', 'CH2EA', 'ML2EA' 'OP2EA', 'OP01', 'RA2EA', 'TR02', 'TR03', 'TR04'), 'Sub_Assembly',
If(Match([Proposed Location], 'PARTROOM','5S11D','6S03E'), 'Kit_Parts')))) as Status,

Re: Nested IF:

Gysbert_Wassenaar — Wed, 30 Jan 2019 17:20:05 GMT

Looks ok. Are you sure that it's really this expression that's causing the error?

What happens if you comment it out?

Have you tried with first one if statement and then if that works adding the next nested if and so on?

Re: Nested IF:

skompel2 — Wed, 30 Jan 2019 17:32:18 GMT

Hey it works now. I followed what gysbert said & wrote each part individually. Surprisingly it didn't throw an error then.

Thanks guys, and I should probably delete this post as it isn't very helpful.

Re: Nested IF:

Gysbert_Wassenaar — Wed, 30 Jan 2019 17:37:18 GMT

No, don't delete it. Somebody else might run into a similar problem and find this as a start to troubleshoot it.