Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Read about the latest Qlik Community enhancements on the Community News blog!
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Erros in Expression: ')' expected

Hello to all,

I'm facing the following issue in my chart:

Error in expression_3.PNG

I have the following variables that are display in my chart:

Variable A = $(vAA)

Variable B = $(vBB)

When I try to divide then, I tried different forms, with paranteses, without and so on....

Case 1:

A/B = $(vAA) / $(vBB)

Error in expression_2.png

Case 2:

After commenting the 'A/B' field.

Error in expression_1.png

Case 3:

Anything different than case 1.

Error in expression_3.PNG

Any idea on the main reason why it is happening?

Kind regards,

Marco Arruda

6 Replies

How are the two variables defined? And you are saying that Case 1 works, but Case 2 and 3 don't?

Master II
Master II

How are the variables defined ?


Using case 1, clear the expression label and hover with the mouse over the expression header.

What do you see?

Not applicable

A = sum({$<Year={$(vLast_Year)}>}$(vRevenuePY))/1000

B = sum({$<Year= {$(vCurrent_Year)}>}$(vRevenue))/1000

Variables used in A and B:

If([$Currency Selector]='EUR', [Revenue EUR],

if([$Currency Selector]='USD', [Revenue USD],

if([$Currency Selector]='CC', [Revenue CC],

if([$Currency Selector]='GBP', [Revenue GBP]))))

=if( GetSelectedCount(Year)=1,Year, Year(Today()))


Case 1
Does not work, because I was expecting a result of (for total): 175.629 / 182.507 = 0.96
What happens is that I have for case 1, that shows only variable A.

Case 3:
When I try to include parentesis or anything like it in my expression.

What I don't understand is why case 1 gives me only variable A instead of the division of variable A / variable B.

Not applicable

I tried to hover over it in the label, definition and the header of the chart (table), but I got nothing.
Am I on the right track?


Can you post an actual screenshot(s) of your variable definition shown in variable overview?