Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
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
Highlighted
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.
Highlighted
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;

Highlighted
Valued Contributor II

Re: Invalid expression in script

Missing , after Load *

Highlighted
Honored Contributor II

Re: Invalid expression in script

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

Re: Invalid expression in script

Hi,

 

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

Highlighted
Valued Contributor II

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

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

Re: Invalid expression in script

yes, i do have. I will try as you suggested.
Highlighted
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