Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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.