topic Syntax Error while creating a variable in QlikView

Syntax Error while creating a variable

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I run into an error while storing a variable in the script. The error message is Syntax error unexpected token and I'm using the following command:

LET vVariable = num(Round(Sum(DISTINCT [column name], 0.01), '$#,##.00')

Does anyone have any idea how to solve this problem?

Thanks.

antoniotiman — Wed, 19 Jul 2017 15:27:55 GMT

LET vVariable = num(Round(Sum(DISTINCT [column name]), 0.01), '$#,##.00')

dhasharadh — Thu, 20 Jul 2017 09:37:39 GMT

LET vVariable = num(Round(Sum(DISTINCT [column name], 0.01), '$#,##.00')

Just forgot to close the extra bracket which is open.