Discussion board for questions on how to use Qlik Community and its features.
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.
my code is as below:
Left Join(Recon)Load *Date(Floor(MonthEnd(Max(Events.CLOSED_TIMESTAMP))), 'M/D/YYYY') as MonthYearresident Events;
Missing , after Load *
After keeping comma as well, it was giving the same expression.
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