Discussion board where members can get started with Qlik Sense.
I have thousands of employees in my database table but I want to fetch only 10 of them.
How can I give the syntax in where clause.
This is my query
SQL select * from Employee
Go to Solution.
Filter using SQL
where employee_name in ('a1','a2','a3');
or in Qlik
load * where match(employee_name,'a1','a2','a3');
SQL select * from Employee;
you can try something like this.
WHERE EmployeeID IN (value1, value2, ...);
Thank You Mohammad & Pradosh
I was using 'in' but it was giving error. So I thought 'in' will not work in data load editor.
But the problem was, I was not using single quote (') between employee code.
After using single quote, problem solved
Please mark the answers correct and helpful ..