This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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
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;
View solution in original post
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 ..