topic Re: Question re. filtering a script by date range in QlikView

Question re. filtering a script by date range

Thu, 22 Oct 2015 14:39:42 GMT

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 ?

Re: Question re. filtering a script by date range

Gysbert_Wassenaar — Thu, 22 Oct 2015 15:51:18 GMT

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;

Re: Question re. filtering a script by date range

Fri, 23 Oct 2015 16:31:03 GMT

Thanks for your help this works .