Qlik Community

New to Qlik Community

Discussion board for questions on how to use Qlik Community and its features.

Announcements
This forum is for questions and information about how to use the Qlik Community.
Please do not post product related questions here.
Select the correct forum from: Qlik Product Forums
Highlighted
andrea0901
New Contributor III

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
Honored Contributor II

Re: Invalid expression in script

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
New Contributor III

Re: Invalid expression in script

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
Contributor III

Re: Invalid expression in script

Missing , after Load *

pradosh_thakur
Honored Contributor II

Re: Invalid expression in script

There is a comma missing after load * as i have mentioned.
Learning never stops.
andrea0901
New Contributor III

Re: Invalid expression in script

Hi,

 

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

anushree1
Contributor III

Re: Invalid expression in script

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
Honored Contributor II

Re: Invalid expression in script

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
New Contributor III

Re: Invalid expression in script

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

Re: Invalid expression in script

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