IF with Error: Garbage after expression

[lucasx15]

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"))

[vinieme12]

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))