Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Re: Error - Expected ')'

Thanks for the suggestion - can you explain how to see if the variables hold data? I'm not seeing anything in the variable overview tab.

sasiparupudi1
Honored Contributor III

Re: Error - Expected ')'

Try in steps.

($(v2017Spending) - $(v2016Spending)) / $(v2017Spending).. if this works,

please try

=num(fabs(

($(v2017Spending) - $(v2016Spending)) / $(v2017Spending)

)

, '(##.00%)')

hth

Sasi

Not applicable

Re: Error - Expected ')'

Thanks for the answer, Sasi. However, that doesn't change the error message.

sasiparupudi1
Honored Contributor III

Re: Error - Expected ')'

Try Changing

=count({<Month = {$(=max(Month)-31)}>} distinct Amount)

to

=count({<Month = {$(max(Month)-31)}>} distinct Amount)

Not applicable

Re: Error - Expected ')'

Here's a screenshot of the error message. The red box is my area of concern.

Highlighted
atkinsow
Valued Contributor II

Re: Error - Expected ')'

Can you provide what each of your variables is calculating out to?

vishsaggi
Esteemed Contributor III

Re: Error - Expected ')'

Can you share your script where you defined these variables?

Not applicable

Re: Error - Expected ')'

vLastMonthSpending:

=count({<Month = {$(=max(Month)-31)}>} distinct Amount)

vMonthSpending:

=count({<Month = {$(=max(Month)-31)}>} distinct Amount)

vishsaggi
Esteemed Contributor III

Re: Error - Expected ')'

Are you using LET or SET here? Can you use a text object and display one of the variables and see what it displays?

And what are the values that hold Month field or they numbers or Text chars like Jan, Feb, Mar.....etc.

May be you need to add some other expression inside your variables..

richard_chilvers
Contributor III

Re: Error - Expected ')'

...was this resolved - I'm getting the same error.

Community Browser