topic Re: Getting error in expression ')' expected but verified all the braces all are balanced. what could be the reason in QlikView

Getting error in expression ')' expected but verified all the braces all are balanced. what could be the reason

deepali_more — Wed, 25 Nov 2020 16:16:04 GMT

Getting error in expression ')' expected but verified all the braces all are balanced. what could be the reason

Re: Getting error in expression ')' expected but verified all the braces all are balanced. what could be the reason

techvarun — Tue, 26 Jun 2018 07:55:30 GMT

Share the expression here

Re: Getting error in expression ')' expected but verified all the braces all are balanced. what could be the reason

manoj217 — Tue, 26 Jun 2018 08:01:48 GMT

If expression is not satisfied it will shows this error.

means it require dimension or expression in ()

Re: Getting error in expression ')' expected but verified all the braces all are balanced. what could be the reason

Peter_Cammaert — Tue, 26 Jun 2018 09:12:06 GMT

If you are getting this while running a reload script, recent versions of QlikView will point to the location where a token was (un)expected. Things you can verify

Function parameter lists: do not specify parameters if the function doesn't accept any
Function parameter list: did you forget a comma somewhere to separate two parameters?
$-sign expansion: do variables and/or expressions expand properly?
Nested IF() calls: in multiple nested IF() calls, it's easy to lose track of parenthesis balancing
...

But the better suggestion is to post your expression for us to analyse.

Best,

Peter

Re: Getting error in expression ')' expected but verified all the braces all are balanced. what could be the reason

deepali_more — Tue, 26 Jun 2018 09:28:42 GMT

PICK(MATCH(VALUELIST($(v_FY_PREM_REV_Concat)),$(v_FY_PREM_REV_Concat))

,$(=$(eRank(Class = {Premium};KPI = {Actual};Year = {"$(=YEAR(TODAY()))"};[Region Code] = {NA})))

,$(=$(eRank(Class = {Premium};KPI = {Actual};Year = {"$(=YEAR(TODAY())-1)"};[Region Code] = {NA})))

,$(=$(eRank(Class = {Premium};KPI = {Actual};Year = {"$(=YEAR(TODAY())-2)"};[Region Code] = {NA})))

,' '

,''

,$(=$(eRank(Class = {Premium};KPI = {Actual};Year = {"$(=YEAR(TODAY()))"};[Quarter] ={Q1;Q2};[Region Code] = {NA})))

,$(=$(eRank(Class = {Premium};KPI = {Actual};Year = {"$(=YEAR(TODAY())-1)"};[Quarter] ={Q1;Q2};[Region Code] = {NA})))

,$(=$(eRank(Class = {Premium};KPI = {Actual};Year = {"$(=YEAR(TODAY())-2)"};[Quarter] ={Q1;Q2};[Region Code] = {NA})))

)

Re: Getting error in expression ')' expected but verified all the braces all are balanced. what could be the reason

ogautier62 — Tue, 26 Jun 2018 09:35:42 GMT

Hi,

in the editor, don't you have a red line ?

may be this a " instead of ' ' :

regards

Re: Getting error in expression ')' expected but verified all the braces all are balanced. what could be the reason

Peter_Cammaert — Tue, 26 Jun 2018 10:58:17 GMT

I guess you are unable to figure out where to look in the first place. An approach could be to gradually disable the different complex components of your expression. For example, an edit like this:

PICK(MATCH(VALUELIST($(v_FY_PREM_REV_Concat)),$(v_FY_PREM_REV_Concat)), 1, 2, 3, 4, 5)

would produce garbage. But if it is accepted as an expression, you can be sure that the problem is in the PICK parameter list, and not in the MATCH parameter list.

If it doesn't work with this simplication, you can then try something like:

PICK(MATCH(VALUELIST($(v_FY_PREM_REV_Concat)), '1', '2', '3', '4', '5'), 1, 2, 3, 4, 5)

If that works, then you can be sure that the problem is situated somewhere in the expansion of v_FY_PREM_REV_Concat into a list of parameters.

And so on...

Best,

Peter

Re: Getting error in expression ')' expected but verified all the braces all are balanced. what could be the reason

olivierrobin — Tue, 26 Jun 2018 11:23:12 GMT

hello

if i paste the expression in editor, it says "Expression OK"

you should take a look at the values of

v_FY_PREM_REV_Concat,v_FY_PREM_REV_Concat

to check if the syntax error is not contained in one of them

Re: Getting error in expression ')' expected but verified all the braces all are balanced. what could be the reason

deepali_more — Tue, 26 Jun 2018 11:45:53 GMT

cheked this it is correct may be while pasting it here in this editor it looked like double quote

Re: Getting error in expression ')' expected but verified all the braces all are balanced. what could be the reason

deepali_more — Wed, 27 Jun 2018 06:47:05 GMT

this variable has : vKPI_YTD_Value = 'YTD-17','YTD-16','YTD-15','FY-17','FY-16','FY-15'