Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Lakshminarayanan_J

Unexpected token: ')', expected one of: ',', 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'OPERATOR_MULTIPLICATION', 'OPERATOR_DIVISION', 'OPERATOR_STRING_CONCA

Dear All,

We are facing the below error for Few Days ,Application had been refreshed on daily basis , but now it is getting failed due to below error,

Error:

Unexpected token: ')', expected one of: ',', 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'OPERATOR_MULTIPLICATION', 'OPERATOR_DIVISION', 'OPERATOR_STRING_CONCAT', 'like', ...

The error occurred here:
ChampDate: LOAD MonthStart(AddMonths(,IterNo()-1)>>>>>>)<<<<<< AS MaDate AUTOGENERATE (1) WHILE MonthStart(AddMonths(,IterNo()-1))<= 44896
 
Table Error Occured :
ChampDate:
LOAD
MonthStart(AddMonths($(vMinDate),IterNo()-1)) AS MaDate
AUTOGENERATE (1)
WHILE MonthStart(AddMonths($(vMinDate),IterNo()-1))<= $(vMaxDate);
 
Kindly let us know why we are facing this error.
 
Lakshminarayanan J
To help users find verified answers, please don't forget to use the "Accept as Solution" button
Labels (2)
1 Solution

Accepted Solutions
Or
MVP
MVP

Presumably, vMinDate isn't getting populated. You can see that there's a blank where a date should be in the parsed version.

View solution in original post

1 Reply
Or
MVP
MVP

Presumably, vMinDate isn't getting populated. You can see that there's a blank where a date should be in the parsed version.