Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
I am getting expression error
this is expression