Discussion Board for collaboration related to QlikView App Development.
I am currently using the script below to populate dates between a slowly changing dimension to determine whether a container is hired out or available.
load *, if(previous(Unit)=Unit, previous([Movement Date]),[Movement Date]+1) as NextDate
order by Unit, [Movement Date] desc;
drop table Movement;
load Unit, date([Movement Date] + IterNo() -1) as [Movement Date], [Available/On-Hire]
while [Movement Date] + IterNo() - 1 < NextDate
order by Unit, [Movement Date];
This has successfully created a row for each date between the first movement date and the last movement date. However I now need to create rows between the last movement date up until today's date.
If anybody has any ideas or advice on how to do this then it would be much appreciated.
Concatenate a record to your Temp2 table before loading result
today() as NextDate
I would use a join and a peek() as described in http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/05/populating-a-sparsely-populated-field