topic Re: Load data in QlikView

Load data

Thu, 25 Jul 2013 10:50:17 GMT

Is it possible to load data with a filter.

We only want records with status Completed loaded. So how to filter the load of data on this criteria.

John

Re: Load data

Gysbert_Wassenaar — Thu, 25 Jul 2013 10:51:49 GMT

With a where clause. Something like this:

Table1:

Load *

from mysource

where Status = 'Completed';

If you load date from an sql database you can include the where statement in the sql statement

Select * from mytable

where Status = 'Completed';

Re: Load data

Thu, 25 Jul 2013 11:12:09 GMT

TRY ACCORDING TO THIS

DATA:

Load *

from DATATABLE

where match(id,'404','408','522');

sql select * from source;

Re: Load data

Gabriel — Thu, 25 Jul 2013 11:35:23 GMT

Hi,

Yes, you can load data with filter. As fellow QV experts have suggested you can use WHERE clause both in SQL statement or in QlikView script (assuming you just load all the data from source , database, flat files i.e. Excel, CSV, without filter).

So something like this: ALL THIS IN QV SCRIPT

Select top(10) *

from YourSource: (From database)

Where JobStatus = 'Complete