Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator II

help

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

2 Replies
Kushal_Chawda

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');

Not applicable

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)';