topic Re: Invalid expression in script in QlikView

Invalid expression in script

andrea0901 — Thu, 07 Feb 2019 05:50:12 GMT

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.

Re: Invalid expression in script

pradosh_thakur — Thu, 07 Feb 2019 05:57:37 GMT

Nothing wrong with the expression. You might be missing a comma or a bracket or something in the previous or next line.

Re: Invalid expression in script

andrea0901 — Thu, 07 Feb 2019 06:05:22 GMT

my code is as below:

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

Re: Invalid expression in script

anushree1 — Thu, 07 Feb 2019 06:18:36 GMT

Missing , after Load *

Re: Invalid expression in script

pradosh_thakur — Thu, 07 Feb 2019 06:22:00 GMT

There is a comma missing after load * as i have mentioned.

Re: Invalid expression in script

andrea0901 — Thu, 07 Feb 2019 06:46:22 GMT

Hi,

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

Re: Invalid expression in script

anushree1 — Thu, 07 Feb 2019 06:52:12 GMT

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

Re: Invalid expression in script

pradosh_thakur — Thu, 07 Feb 2019 07:00:13 GMT

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.

Re: Invalid expression in script

andrea0901 — Thu, 07 Feb 2019 07:25:10 GMT

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

Re: Invalid expression in script

Sue_Macaluso — Mon, 11 Feb 2019 14:53:40 GMT

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