topic Re: Error - Expected ')' in QlikView

Error - Expected ')'

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I'm struggling to identify where the error is occurring in the following expression:

=Month(max(Date)) & ' vs ' & Month(max(Date)-31) & chr(10) & 'Spending' & chr(10) &

num(fabs($(vMonthSpending) - $(vLastMonthSpending) / $(vMonthSpending)), '(##.00%)')

I'm trying to get a text output of a selected month vs. last month's spending increases as a percentage.

Here is the expression for the Year vs. Last Year spending increase that executes successfully:

=max(Year) & ' vs ' & (max(Year)-1) & chr(10) & 'Spending' & chr(10) &

num(fabs($(v2017Spending) - $(v2016Spending) / $(v2017Spending)), '(##.00%)')

Any advice or assistance is much appreciated.

Best,

Re: Error - Expected ')'

vishsaggi — Fri, 16 Jun 2017 20:20:50 GMT

Where are you getting this error? in Text box or while reloading? Can you share a snapshot?

Re: Error - Expected ')'

Anonymous — Fri, 16 Jun 2017 20:30:21 GMT

Yours looked fine but you could try...................

=Month(max(Date)) & ' vs ' & Month(AddMonths(Monthstart(max(Date)),-1)) & chr(10) & 'Spending' & chr(10) &
num(fabs($(vMonthSpending) - $(vLastMonthSpending) / $(vMonthSpending)), '(##.00%)')

Re: Error - Expected ')'

Fri, 16 Jun 2017 20:31:51 GMT

on the last part try removing the quotes, and putting the % at the end with & '%'

Re: Error - Expected ')'

Fri, 16 Jun 2017 21:06:05 GMT

Hey Wallo,

Just gave this a try and I'm still getting the same error readout. Thanks for the suggestion, but I'm still not sure what the issue is.

Re: Error - Expected ')'

Anonymous — Fri, 16 Jun 2017 21:30:31 GMT

Can you share a sample app?

Re: Error - Expected ')'

Anonymous — Fri, 16 Jun 2017 21:43:12 GMT

You could try

=Month(max(Date)) & ' vs ' & Month(AddMonths(Monthstart(max(Date)),-1)) & chr(10) & 'Spending' & chr(10) & '(' &
num(fabs($(vMonthSpending) - $(vLastMonthSpending) / $(vMonthSpending)), '##.00%') & ')'

Re: Error - Expected ')'

jwbadger3 — Sat, 17 Jun 2017 01:42:16 GMT

Also try checking your variable expressions. It's possible you're missing something in one of them and the error is occurring during the dollar sign expansion on execution of the expression.

Re: Error - Expected ')'

Sat, 17 Jun 2017 23:21:09 GMT

Here is the variable script:

vLastMonthSpending:

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

vMonthSpending:

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

Re: Error - Expected ')'

vishsaggi — Sun, 18 Jun 2017 14:13:43 GMT

When you check your variables are they holding any data? Use Ctrl+Alt+V and see what values you can see for these variables? Can you share a sample if possible that has this issue?

Re: Error - Expected ')'

Sun, 18 Jun 2017 17:49:23 GMT

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.

Re: Error - Expected ')'

sasiparupudi1 — Sun, 18 Jun 2017 20:02:08 GMT

Try in steps.

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

please try

=num(fabs(

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

)

, '(##.00%)')

hth

Sasi

Re: Error - Expected ')'

Mon, 19 Jun 2017 00:20:54 GMT

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

Re: Error - Expected ')'

sasiparupudi1 — Mon, 19 Jun 2017 13:29:46 GMT

Try Changing

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

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

Re: Error - Expected ')'

Mon, 19 Jun 2017 14:17:37 GMT

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

Re: Error - Expected ')'

Anonymous — Mon, 19 Jun 2017 19:56:25 GMT

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

Re: Error - Expected ')'

vishsaggi — Mon, 19 Jun 2017 19:59:39 GMT

Can you share your script where you defined these variables?

Re: Error - Expected ')'

Mon, 19 Jun 2017 20:08:10 GMT

vLastMonthSpending:

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

vMonthSpending:

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

Re: Error - Expected ')'

vishsaggi — Mon, 19 Jun 2017 20:23:08 GMT

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..

Re: Error - Expected ')'

richard_chilvers — Wed, 24 Jan 2018 14:45:22 GMT

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