Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

whats the wrong in my logic

LOAD * INLINE [

     startdate, enddate

     20/07/2015,  30/07/2015

]
;



date1:

load  date(Date#(startdate,'DD/MM/YYYY'),'MM/DD/YYYY') as start_date,

date(Date#(enddate,'DD/MM/YYYY'),'MM/DD/YYYY') as end_date



resident date;



drop table date;

let stratdate1=num(peek(start_date));

let enddate1=num(peek(end_date));







load date($(stratdate1)+IterNo()-1) as startdate1

AutoGenerate 1

while IterNo()<= ($(enddate1) - $(stratdate1));

11 Replies
Not applicable
Author


My problem resolved i missed ' ' in peek function thanks for replying

qlikviewwizard
Master II
Master II

Hi ranganna

If your issue is resolved please close thread by selecting Correct Answer