topic Re: Conditional Match not working properly in QlikView

Conditional Match not working properly

saivina2920 — Sat, 16 Nov 2024 04:01:33 GMT

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..?

Re: Conditional Match not working properly

PrashantSangle — Thu, 28 Mar 2019 10:20:30 GMT

try by removing " before and after EMPNO
If it still not work.
Please provide more info

when you run without where condition then is it capturing record for EP100001? can you share screen shot of it.
Is it EMPNO contain space before or after EP100001 value?
try below suggestion instead of Where Match("EMPNO",'EP100001')
1:Where EMPNO='EP100001';
2: Where trim(UPPER(EMPNO))='EP100001';
3: Where wildmatch(EMPNO,'EP100001');

Regards,
Prashant Sangle

Re: Conditional Match not working properly

saivina2920 — Thu, 28 Mar 2019 11:32:11 GMT

I used all the three below. but, still return 0 records. .
when i run without where condition, it showing all the records.
1:Where EMPNO='EP100001';
2: Where trim(UPPER(EMPNO))='EP100001';
3: Where wildmatch(EMPNO,'EP100001');
?????

Re: Conditional Match not working properly

PrashantSangle — Thu, 28 Mar 2019 11:37:55 GMT

when you run without condition then check data is available for EP100001?

try below
Temp:
LOAD "EMPNO",
"EMPNAME",
"DEPARTMENT"
;
SQL SELECT *
FROM EMPSCHEMA."EMPLOYEELIST";
NoConcatenate
Test:
Load *
Resident Temp
Where EMPNO='EP100001';

Drop table Temp;

Re: Conditional Match not working properly

sunny_talwar — Thu, 28 Mar 2019 11:38:19 GMT

Are you sure you have EP100001 within EMPNO?

Re: Conditional Match not working properly

saivina2920 — Thu, 28 Mar 2019 11:55:41 GMT

yes...

Re: Conditional Match not working properly

sunny_talwar — Thu, 28 Mar 2019 11:57:11 GMT

I guess that is what @PrashantSangle hinted towards... can you load the complete data and share a screenshot for EMPNO in a list box so that we can see EP100001 in the data to see how it looks like.

Re: Conditional Match not working properly

saivina2920 — Thu, 28 Mar 2019 12:03:35 GMT

The below query is working... How...?
Temp:
LOAD "EMPNO",
"EMPNAME",
"DEPARTMENT"
;
SQL SELECT *
FROM EMPSCHEMA."EMPLOYEELIST";
NoConcatenate
Test:
Load *
Resident Temp
Where EMPNO='EP100001';

Drop table Temp;

Can we simplified the query again in simple way...?

Re: Conditional Match not working properly

PrashantSangle — Thu, 28 Mar 2019 12:08:54 GMT

yes.
use where condition in sql statement;

try below
TABLE1:
LOAD "EMPNO",
"EMPNAME",
"DEPARTMENT"
;
SQL SELECT *
FROM EMPSCHEMA."EMPLOYEELIST"
Where EMPNO='EP100001'
;

If you want enter multiple no then use in()

Re: Conditional Match not working properly

saivina2920 — Thu, 28 Mar 2019 12:28:11 GMT

What happened if i pass multiple values in where condition...like ('EP100001','EP100010',..).
Will it work...?

Re: Conditional Match not working properly

PrashantSangle — Thu, 28 Mar 2019 12:33:06 GMT

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

Re: Conditional Match not working properly

saivina2920 — Thu, 28 Mar 2019 12:34:59 GMT

Qlikview 11.0