Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Pomna
Creator III
Creator III

IterNo

l would like to generate dates between two dates . That is, [Start Date] and [End Date]. But when I run the code below it runs with out end. Below is the code. I would like to know what am doing wrong. Thanks for your suggestions

 

[HR Status DatesTmp]:
Load *,
Date([Start Date] + IterNo() - 1 ) as [Status Date]
Resident [Applicant]
While IterNo() <= Date([Start Date]) - Date([End Date]) + 1 ;

2 Replies
MayilVahanan

Hi Pomna,

Try like below

Load *,
Date([Start Date] + IterNo() - 1 ) as [Status Date]
Resident [Applicant]
While Floor([Start Date]) + IterNo()-1 <= Floor([End Date]);

Thanks & Regards,
Mayil Vahanan R
rwunderlich

I think you just reversed Start & End. Should be:

While IterNo() <=Date([End Date])  - Date([Start Date])  + 1 ;