Conditional Match not working properly

[saivina2920]

I'm using where condition with Match. But, this will not return anything. below is my query. It will return zero record found.

TABLE1:
LOAD "EMPNO",
"EMPNAME",
"DEPARTMENT"
Where Match("EMPNO",'EP100001');
SQL SELECT *
FROM EMPSCHEMA."EMPLOYEELIST";

What is the problem in the above query..?

[PrashantSangle]

yes try below syntax

where EMPNO in ('EP10001','EP100010');

But I am still not getting why where condition is not working in preceding load. which qliksense version are you using?

Regards,
Prashant Sangle

[saivina2920]

Qlikview 11.0