topic Error: Garbage after expression: ')' in QlikView

Error: Garbage after expression: ')'

Wed, 25 Nov 2020 16:16:04 GMT

I am adding a trigger to a field in document properties using the following if statement

=If(GetFieldSelections([Analytical Type])='Timeliness',1,
If(GetFieldSelections([Analytical Type])='Accuracy',2,
If(GetFieldSelections([Analytical Type])='Completeness',3,
If(GetFieldSelections([Analytical Type])='Validity',4,
0))))

However I keep getting the error above.

Any ideas what wrong?

Re: Error: Garbage after expression: ')'

sunny_talwar — Thu, 12 Oct 2017 19:38:25 GMT

Don't see anything wrong, but you can try with this

=Match(GetFieldSelections([Analytical Type]), 'Timeliness', 'Accuracy', 'Completeness', 'Validity')

Re: Error: Garbage after expression: ')'

vishsaggi — Thu, 12 Oct 2017 19:41:53 GMT

Are there any hidden brackets before adding your IF script just click Ctrl+A and delete. Then add the IF statements. Just in case..

Re: Error: Garbage after expression: ')'

ziadm — Thu, 12 Oct 2017 19:58:49 GMT

remove the = sign infront of the expression

If(GetFieldSelections([Analytical Type])='Timeliness',1,
If(GetFieldSelections([Analytical Type])='Accuracy',2,
If(GetFieldSelections([Analytical Type])='Completeness',3,
If(GetFieldSelections([Analytical Type])='Validity',4,
0))))

Re: Error: Garbage after expression: ')'

vishsaggi — Thu, 12 Oct 2017 20:02:59 GMT

Hello Ziad,

i wonder why = sign would effect here?

Re: Error: Garbage after expression: ')'

andrei_delta — Fri, 13 Oct 2017 07:44:46 GMT

Hello,

I came across this problem recently...you can put the GetFieldSelections([Analytical Type] in a variable and then use your expression like this:

If($(YourVar)='Timeliness',1,

If($(YourVar)='Accuracy',2,

If($(YourVar)='Completeness',3,

If($(YourVar)='Validity',4,

)

Hope it helps,

Andrei

Re: Error: Garbage after expression: ')'

Peter_Cammaert — Fri, 13 Oct 2017 08:18:50 GMT

Maybe replace the second equal sign by a comma?

Re: Error: Garbage after expression: ')'

sunny_talwar — Fri, 13 Oct 2017 11:18:25 GMT

Fixed