Load only current month per time in Qliksense

[Anonymous]

I am getting this error from this code

LOAD.........

........

.....

FROM ............................

Where DateEntered>=MonthStart(Now()) and DateEntered<=MonthEnd(Now());

Same applies to when I use Today()).

PS: Its an ODBC connection to a SQL Server DB

[Digvijay_Singh]

Hi,

You cannot use Qlik functions in the SQL statement. You may either try to achieve same through SQL functions or use Where clause in preceeding load, something like this -

LOAD.........

........

Where DateEntered>=MonthStart(Now()) and DateEntered<=MonthEnd(Now());

;

FROM ............................

SourceFile;

[Anonymous]

Thank you Digvijay, It worked out perfectly

[Digvijay_Singh]

Glad it worked. Please close the thread by marking correct answer or post more questions if you need more help.