Discussion Board for collaboration on QlikView Scripting.
A number of posts suggested that Wildmatch could be used in a WHERE clause. However, I am getting this error:
The syntax seems correct. Am I missing something?
Wildmatch is a Qlikview specific function and can only be used in the WHERE clause of a LOAD statement. Here you are using it in a SQL statement. Try replacing it with CH.REF LIKE 'Updated(1): Salesperson%'
WildMatch() is a QlikView function, not a SQL function. The Select statement is sent in its entirety to the Database Management System, which doesn't recognize WildMatch.
You can use WildMatch() in a QlikView statement like LOAD, but not in a Select.
WildMatch() is a QlikView function,do not use filters in select statement,apply filters in load statement.
Where WILDMATCH(CH.REF, '*Updated(1): Salesperson%*') and ONDATE >= '01/01/2015';
Select * From ContHist;
if you want to use wildmatch, use Neehta answer, the rows are filtered in QlikView (all record from database, filter in Qlik)
if you want to filter at the database side use like (in SQL) and remove wildmatch (from the Qlik part)
CH.REF like '%Updated(1): Salesperson%'
and ONDATE >= '01/01/2015'