topic Re: Load only current month per time in Qliksense in Connectivity & Data Prep

Load only current month per time in Qliksense

Anonymous — Mon, 12 Mar 2018 10:38:16 GMT

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

Re: Load only current month per time in Qliksense

Digvijay_Singh — Mon, 12 Mar 2018 18:20:12 GMT

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;

Re: Load only current month per time in Qliksense

Anonymous — Tue, 13 Mar 2018 10:48:20 GMT

Thank you Digvijay, It worked out perfectly

Re: Load only current month per time in Qliksense

Digvijay_Singh — Tue, 13 Mar 2018 14:08:00 GMT

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