topic Garbage after statement error in QlikView

Garbage after statement error

Oussama-Hennani — Thu, 28 Jan 2021 08:48:48 GMT

Hello QlikView Community,

It's been 1 month that I'm looking for a solution to the garbage after statement error. Unfortunately, I cannot find the solution until now. If someone knows what can be the problem in the script or else that causes this error.

Thanks a lot for your help.

Re: Garbage after statement error

marcus_sommer — Thu, 28 Jan 2021 14:55:19 GMT

I think this is your problem:

means you used a timestamp instead of a date within addmonths() and the while-loop which is logically not quite correct but not a technically issue - but those values have the wrong format because the decimal-delimiter is a comma (is in Qlik always treated as parameter-delimiter) and not a dot/point.

To overcome the issue you could change the delimiter with num() or probably even better you cut the timepart to get a real date, maybe with: date(floor(YourTimestamp)).

- Marcus

Re: Garbage after statement error

Oussama-Hennani — Wed, 24 Feb 2021 08:45:07 GMT

Hello Sir,

Thank you for the answer, and sorry for my late one.

I used num() between the variables and it works.

Thanks a lot.