Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load with where

Hi

Is it possible to load from a DB with a where? I would like to load all data since 10.06.2013 and not older. Is that possible?

11 Replies
Not applicable
Author

Then i get the error "Schlüsselwort FROM nicht an erwarteter Stelle gefunden" -> Code(?) word not found at the correct position

tresesco
MVP
MVP

Try:  // this will compromise your performance though

ODBC CONNECT TO [xx] (xxxx);

Load Date(Floor(DATETIME)) as Date Where Date(DATETIME,'DD.MM.YYYY')>='19.08.2013';

SQL SELECT ACTION,

                        ID,

                        DATETIME

WHERE

FROM RORC."RORC_ORDERS_FEED";