topic Re: Erros in Expression: ')' expected in QlikView

Erros in Expression: ')' expected

Tue, 17 May 2016 20:16:56 GMT

Hello to all,

I'm facing the following issue in my chart:

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)

Case 2:

After commenting the 'A/B' field.

Case 3:

Anything different than case 1.

Any idea on the main reason why it is happening?

Kind regards,

Marco Arruda

Re: Erros in Expression: ')' expected

sunny_talwar — Tue, 17 May 2016 20:45:27 GMT

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

Re: Erros in Expression: ')' expected

trdandamudi — Tue, 17 May 2016 20:46:25 GMT

How are the variables defined ?

Re: Erros in Expression: ')' expected

swuehl — Tue, 17 May 2016 20:48:07 GMT

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

What do you see?

Re: Erros in Expression: ')' expected

Wed, 18 May 2016 11:39:39 GMT

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

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

Variables used in A and B:
vRevenue:

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

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

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

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

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

vLast_Year:
=$(vCurrent_Year)-1

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.

Re: Erros in Expression: ')' expected

Wed, 18 May 2016 11:43:56 GMT

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?

Re: Erros in Expression: ')' expected

swuehl — Wed, 18 May 2016 12:02:20 GMT

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