topic Filter Records in QlikView

Filter Records

Mon, 17 May 2010 13:10:44 GMT

Hi,

I want to filter out the records from the Qvd file by Using Load * from tablename where fieldname in (1,2,3)

It gives Error while executing the statement but the same work in SQL, Pls suggest the option.

Thanks,

Arun

Mon, 17 May 2010 13:45:19 GMT

Hi Arun,

While loading the data, you cannot specify the 'in' keyword'. What you have to do is, you have to load and give the condition as given below.

Load * from tablename where fieldname = 1 or fieldname = 2 or fieldname = 3;

Just try this. This works fine for me. Hope this helps.

Thanks Joseph.

Mon, 17 May 2010 13:58:42 GMT

Hi Arun

I think you can also use the MATCH function instead of IN as follows:

LOAD * From TableName WHERE MATCH(FieldName,1,2,3)