topic Re: SQL Query (if/wildmatch) in QlikView

SQL Query (if/wildmatch)

Jacob — Sat, 16 Nov 2024 03:53:42 GMT

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.

Re: SQL Query (if/wildmatch)

dplr-rn — Wed, 10 Apr 2019 20:53:54 GMT

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

Re: SQL Query (if/wildmatch)

Jacob — Thu, 11 Apr 2019 05:49:49 GMT

I am getting expression error

this is expression

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