i suggest stepping through your code with the debugger to figure out if there is any loop happening. One guess is just that the formats are not compatible because one side is using an addition and the other is not .
LOAD $(vMinDate) + (IterNo()-1) as Date
while date($(vMinDate)+ (IterNo()-1))<= date($(vMaxDate));
Here is also an alternative code:
LOAD date( $(vMinDate) + (IterNo()-1)) as Date
autogenerate $(vMaxDate)-$(vMinDate)+1 ;
The basic issue that I can see is formatting your min and max values as dates - the date values don't work as well in the following logic. Try the same, keeping the numbers as numeric values.
The second problem is that the last load doesn't have any source of the data (from/resident/autogenerate) and therefore it's considered as a Preceding load. I added Autogenerate to your logic.
www.masterssummit.com - take your QlikView skills to the next level!
max(ORDERS.SO_DTL_CRT_DT) as MaxDate,
min(ORDERS.SO_DTL_CRT_DT) as MinDate
LET vMaxDate = Peek('MaxDate',0,'Dates');
LET vMinDate = Peek('MinDate',0,'Dates');
DROP Table Dates;
Date($(vMinDate) + (IterNo()-1)) as Date
while $(vMinDate)+ (IterNo()-1)<= $(vMaxDate)