Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Using WHERE in LOAD

Hello,
I'd like some help on how to create a where clause in the load so I dont have to load all the old redundant data
SQL SELECT * FROM G_Ldatabase.dbo."G_L Entry" WHERE 'Posting Date' > '01/08/2005';
sorry if this seems a simple question I am just figuring out qlikview
Thank you for your time it's much appreciated
1 Solution

Accepted Solutions
Not applicable

Using WHERE in LOAD

Try this:

Test:

LOAD

PostingDate,

DTEISS,

DATERETN,

TERMID,

"USER",

"TRANSACTION_DATE",

"TRANSACTION_TIME",

"USER_PROFILE",

"JOB_NAME",

DATIME;

SQL SELECT *

FROM B005592P.ITGDTA.COINPF

where PostingDate > '01/08/2005';

2 Replies
Not applicable

Using WHERE in LOAD

Try this:

Test:

LOAD

PostingDate,

DTEISS,

DATERETN,

TERMID,

"USER",

"TRANSACTION_DATE",

"TRANSACTION_TIME",

"USER_PROFILE",

"JOB_NAME",

DATIME;

SQL SELECT *

FROM B005592P.ITGDTA.COINPF

where PostingDate > '01/08/2005';

Not applicable

Using WHERE in LOAD

Thanks for that. I relised that posting date was suppose to have speach marks as it was two words