topic Re: I can't figure out my Script Error in QlikView

I can't figure out my Script Error

robinwiman — Thu, 26 Oct 2017 08:31:01 GMT

I get a syntax error when I debug my scripts.

I've tried to make changes and revert them back with no luck.

I am not sure, but this part seems a bit worrying:

FROM >>>>>>.<<<<<<.\QVD\Budget.qvd (qvd)

where year(Date) >= Year(today())-1

It may be very hard to tell what seems to be the problem, but I have no clue where to start.

Re: I can't figure out my Script Error

Chanty4u — Thu, 26 Oct 2017 08:32:53 GMT

missing semi coloun ;

\QVD\Budget.qvd (qvd)

where year(Date) >= Year(today())-1 ;

Re: I can't figure out my Script Error

Anil_Babu_Samineni — Thu, 26 Oct 2017 08:34:14 GMT

Try to debug in script, and what i found is one Comma added for last column,, That we need to remove

Re: I can't figure out my Script Error

Chanty4u — Thu, 26 Oct 2017 08:35:00 GMT

or set a vaariable and use this in condition

let vYear=Year(today())-1;

where year(Date) >= $(vYear);

where year(Date) >=' $(vYear)';

Re: I can't figure out my Script Error

tresB — Thu, 26 Oct 2017 08:35:03 GMT

Remove comma (,) after last field name [Item Group]

Re: I can't figure out my Script Error

robinwiman — Thu, 26 Oct 2017 08:39:53 GMT

I had the Semicolon, but it is not shown in the error window. Thank you for your help, I appreciate it!

Re: I can't figure out my Script Error

robinwiman — Thu, 26 Oct 2017 08:40:13 GMT

this did the trick! Thank you for your help, I appreciate it!

Re: I can't figure out my Script Error

stabben23 — Thu, 26 Oct 2017 08:41:36 GMT

Hi Robin,

maybe that year(Date) gives you a numeric year as its from a QVD, like 429xx

Or try where year(Date) >='2016' to se if it reload.

Re: I can't figure out my Script Error

robinwiman — Thu, 26 Oct 2017 08:42:25 GMT

Thank you, this is the correct solution! Anil Babu Samineni posted the solution just a minute before you and I will mark his answer as correct. I appreciate your help!

Re: I can't figure out my Script Error

robinwiman — Thu, 26 Oct 2017 08:43:40 GMT

Thank you, Staffan. I found the solution to the error being an excessive comma.

Re: I can't figure out my Script Error

Chanty4u — Thu, 26 Oct 2017 08:47:12 GMT

mY BAD,

I didnt see your attached image