Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

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

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