Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Question re. filtering a script by date range


Is there an expression that you can insert into a script to filter the incoming data (say from a database) by date range before it is loaded into the app e.g. all data ater a certain date or should it always be filtered first in the database ideally ?

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Question re. filtering a script by date range

You can add a where clause to a load script block:

Example1:

LOAD * FROM MyTable.qvd (qvd) WHERE MyDate <= Today();

Example2:

SQL SELECT * FROM MyTable WHERE MyYear <= 2015;


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Question re. filtering a script by date range

You can add a where clause to a load script block:

Example1:

LOAD * FROM MyTable.qvd (qvd) WHERE MyDate <= Today();

Example2:

SQL SELECT * FROM MyTable WHERE MyYear <= 2015;


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Not applicable

Re: Question re. filtering a script by date range

Thanks for your help this works .