Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Jacob
New Contributor II

SQL Query (if/wildmatch)

Hi everyone,

I have sql query and i trying to implement qlikview but i getting error.

SQL

(SELECT MIN(Adate) 
FROM xyz A1
WHERE A1.dff=A.nid
P_number IN (58,656,46,49,10) ),'DD-MM-YYYY') NDate

 Expression

if(wildmatch(P_number , 58,656,46,49,10), Date(min(Adate )), DD-MM-YYYY) as NDate

 

anyone can plz help.

Labels (5)
2 Replies
Partner
Partner

Re: SQL Query (if/wildmatch)

what is the error?
quick look at the syntax is wrong. see below delete red and add green
if(wildmatch(P_number , 58,656,46,49,10), Date(min(Adate )), DD-MM-YYYY) )as NDate

Jacob
New Contributor II

Re: SQL Query (if/wildmatch)

I am getting expression error

this is expression

if(WildMatch(P_number ,'58','6568','46'),Date(Min(Adate ),'DD-MM-YYYY')) as NDate