Having in Qlikview

Anonymous — Tue, 19 Mar 2013 10:37:13 GMT

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

Re: Having in Qlikview

Tue, 19 Mar 2013 10:41:48 GMT

Hello Leni,

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

thanks,

itsangad

Re: Having in Qlikview

Anonymous — Tue, 19 Mar 2013 12:34:36 GMT

Thanks it worked

topic Re: Having in Qlikview in QlikView

Having in Qlikview

Re: Having in Qlikview

Re: Having in Qlikview