topic Re: Where clause not working for Ms-Access datasource in QlikView

Where clause not working for Ms-Access datasource

Mon, 11 Jan 2016 09:13:45 GMT

Hi Team,

I want to load data from MS-Access with limiting data from a particular column i.e Team in my case. I have written below script but could not achieve it. It is throwing some error

Attendance1:

Load Attendance,

Team,

Emp Name,

Designation

Select * from Attandence where Team in('ABC','AVP','PQR');

Please help me.

Thanks in Advance

Regards

Priyanka

Re: Where clause not working for Ms-Access datasource

jonathandienst — Mon, 11 Jan 2016 09:17:23 GMT

Your SQL expression looks fine, but you need a delimiters for Emp Name, semicolon after Designation, and a SQL keyword before the Select:

Load Attendance,

Team,

[Emp Name],

Designation;

SQL Select * from Attandence where Team in('ABC','AVP','PQR');

(Is the table name spelled correctly).

If you supplied more information about the error, it would allow more accurate diagnosis. "Some error" could be just about anything...