Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Load only current month per time in Qliksense

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

3 Replies
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
Not applicable
Author

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.