Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
deepali_more
Creator
Creator

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

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

9 Replies
techvarun
Specialist II
Specialist II

Share the expression here

manoj217
Creator III
Creator III

If expression is not satisfied it will shows this error.

means it require dimension or expression in ()

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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

deepali_more
Creator
Creator
Author

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

)

ogautier62
Specialist II
Specialist II

Hi,

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

may be this a " instead of ' ' :

regards

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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


olivierrobin
Specialist III
Specialist III

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

deepali_more
Creator
Creator
Author

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

deepali_more
Creator
Creator
Author

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