topic Re: help in QlikView

help

NavinReddy — Wed, 31 Jul 2013 04:31:46 GMT

hi All

some one help me to find error

Temp1_Max_Date:

load max([Date Identifier]) as [Max Business Date] resident Date;

let vMaxDate= Date(peek('Max Business Date '),'DD-MM-YYYY');

Temp2_Date;

load [Date Identifier] as [test date1] resident Date where [Date identifier]='$(vMaxDate)';

LET vdate1=peek('text date');

Thanks in advance

rohith

Kushal_Chawda — Wed, 31 Jul 2013 04:43:57 GMT

Hi,

may be like this

Temp1_Max_Date:

load max(date(date#([Date Identifier],'DD-MM-YYYY'),'DD-MMM-YYYY')) as [Max Business Date] resident Date;

let vMaxDate= Date(peek('Max Business Date',0,'Temp1_Max_Date'),'DD-MM-YYYY');

Wed, 31 Jul 2013 05:50:10 GMT

try this

Temp1_Max_Date:

load max([Date Identifier]) as [Max Business Date] resident Date;

let vMaxDate= peek('[Max Business Date]',0,'Temp1_Max_Date');

Temp2_Date:

load [Date Identifier] as [test date1] resident Date where [Date identifier]='$(vMaxDate)';