Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"))
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))