topic Error in Expression ')' expected, tried everything but now workinf in QlikView

Error in Expression ')' expected, tried everything but now workinf

vikasshana — Thu, 15 Jul 2021 06:00:30 GMT

Hi,

I have the below code and when I'm using a text box to write an expression I'm getting error message like 'Error in Expression: ')' expected', not sure what is wrong in it.

Let vTest=2;

Let vCurrent = max(Year);

Let vBefore = ($(vCurrent)-1)

In my Text Object I'm using below code and is not working.

=num(pick($(vTest),sum($(vBefore )Sales1),sum($(vBefore )Sales2)),'$#,##0;-$#,##0')

Regards,

Re: Error in Expression ')' expected, tried everything but now workinf

tresB — Thu, 15 Jul 2021 06:13:21 GMT

There could be more than one issue here. It seems that, you are trying to calculate current/previous year sales amount based on vTest variable value. If so, missing part is 'Year' in set analysis. Try to share a sample data set and explain your expected output in that context.

Re: Error in Expression ')' expected, tried everything but now workinf

vikasshana — Thu, 15 Jul 2021 08:39:28 GMT

Made some changes and got it resolved. Thanks for your help @tresB