Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
andrea0901
Creator
Creator

Invalid expression in script

hi all,

 

i am using the below expression in script and it is throwing error as invalid expression.

 

Date(Floor(MonthEnd(Max(Events.CLOSED_TIMESTAMP))), 'M/D/YYYY') as MonthYear

please help me out.

9 Replies
pradosh_thakur
Master II
Master II

Nothing wrong with the expression. You might be missing a comma or a bracket or something in the previous or next line.
Learning never stops.
andrea0901
Creator
Creator
Author

Hi 

my code is as below:

Left Join(Recon)
Load *
Date(Floor(MonthEnd(Max(Events.CLOSED_TIMESTAMP))), 'M/D/YYYY') as MonthYear
resident Events;

anushree1
Specialist II
Specialist II

Missing , after Load *

pradosh_thakur
Master II
Master II

There is a comma missing after load * as i have mentioned.
Learning never stops.
andrea0901
Creator
Creator
Author

Hi,

 

After keeping  comma as well, it was giving the same expression.

anushree1
Specialist II
Specialist II

Could you comment out the line below load * (remove , ) as the next statement should be from/resident and try again ; so that we check if the line post load * is causing the issue

pradosh_thakur
Master II
Master II

Do you have Events.CLOSED_TIMESTAMPin the Events table ? If the name is qualified then only use Events.CLOSED_TIMESTAMP else CLOSED_TIMESTAMP will do.
Learning never stops.
andrea0901
Creator
Creator
Author

yes, i do have. I will try as you suggested.
Sue_Macaluso
Community Manager
Community Manager

Is this for QlikView or Qlik Sense? I'd like to move this to the appropriate product forum.
Sue Macaluso