Having in Qlikview

[Anonymous]

Hi All,

Could you please help me in converting the below qlikview statement. Currently I am fetching directly from the database, now I need to replace this statement with qvd (instead of databse need to use Qvd files). So I need to use only Load statement and not the SQL part. I dono how to use "having" in Load statement.

Can anyone help me??

LOAD date(floor(CREATE_DATE)+1) as FROMDATE

,if(today()>floor(CREATE_DATE)+1, today(), date(floor(CREATE_DATE)+1)) as TODATE

;

SQL SELECT MAX(CREATE_DATE) as CREATE_DATE

FROM db.Table_Name

WHERE CODE = '$(Code)'

HAVING TRUNC(MAX(CREATE_DATE)) < TRUNC(SYSDATE);

Thanks,

Leni

[#2 · Accepted solution]

Hello Leni,

You must use Preceeding Load , Check this out.http://community.qlik.com/thread/15278

thanks,

itsangad

[Anonymous]

Thanks it worked