IF with Error: Garbage after expression

lucasx15 — Fri, 13 Jan 2023 20:12:38 GMT

Hello everyone. I'm new to qlikview. I recently needed to add an aggregation expression to a text object. I added it inside a variable in which I called vOcup, this variable has an 8 which is the code of a client that I defined in my filter. however, it returned the error of IF with Error: Garbage after expression: ','. I couldn't understand where the error is. Because in my script no error was flagged.

This my expression:

= IF(num(AVG( INTERN.OCUP),'#0,0') > avg( TOTAL.OCUP), num(AVG( INTERN.OCUP),'#0,0') & '/' & avg(TOTAL.OCUP), num(AVG( INTERN.OCUP),'#0,0') & '/' & avg( TOTAL.OCUP))

This my object text that returns Error: Garbage after expression: ','.:

=$(vOcup("8"))

Re: IF with Error: Garbage after expression

vinieme12 — Mon, 16 Jan 2023 03:21:58 GMT

Are you Trying to create a parameterized variable ?

If not, then just this is needed

=$(vOcup)

refer this if you are trying to create a parameterized variable

https://analyticshub.io/2020/04/28/creating-parameterized-variable-in-qlik-sense-and-qlikview/

= IF( AVG(INTERN.OCUP) > avg( TOTAL.OCUP), num(AVG(INTERN.OCUP),'#0,0') & '/' & avg(TOTAL.OCUP), num(AVG(INTERN.OCUP),'#0,0') & '/' & avg( TOTAL.OCUP))

topic Re: IF with Error: Garbage after expression in App Development

IF with Error: Garbage after expression

Re: IF with Error: Garbage after expression