Discussion Board for collaboration on QlikView Scripting.
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
Select * from Attandence where Team in('ABC','AVP','PQR');
Please help me.
Thanks in Advance
Go to Solution.
Your SQL expression looks fine, but you need a delimiters for Emp Name, semicolon after Designation, and a SQL keyword before the Select:
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...