https://community.qlik.com/t5/Insight-Advisor/Need-Help-with-looping-through-dates/m-p/2021762#M195 <P>This would typically be handled using something along the lines of (Note: Code may not be exactly correct but should be in the ballpark):</P> <P>Load ID, start - 1 + IterNo()</P> <P>From YourTable</P> <P>While IterNo() &lt; (end - start)+1</P> Wed, 04 Jan 2023 13:41:45 GMT Or 2023-01-04T13:41:45Z https://community.qlik.com/t5/Insight-Advisor/Need-Help-with-looping-through-dates/m-p/2020969#M194 <P>Hi,</P> <P>I am trying to store qvds based on each single day. I have the data In db as</P> <P>Id, start, end 1, 12/1/2022, 12/30/2022</P> <P>The above record was actually stored as one record in db but the record was available for 30 days. So in general I need 30 qvds with same record showing up. I was able to get the records seperated out but need help in storing the qvds using loop instead of manually doing the work.</P> <P>Please provide your thoughts. Any help is highly appreciated!!</P> Sun, 01 Jan 2023 22:18:29 GMT https://community.qlik.com/t5/Insight-Advisor/Need-Help-with-looping-through-dates/m-p/2020969#M194 yuwon44 2023-01-01T22:18:29Z https://community.qlik.com/t5/Insight-Advisor/Need-Help-with-looping-through-dates/m-p/2021762#M195 <P>This would typically be handled using something along the lines of (Note: Code may not be exactly correct but should be in the ballpark):</P> <P>Load ID, start - 1 + IterNo()</P> <P>From YourTable</P> <P>While IterNo() &lt; (end - start)+1</P> Wed, 04 Jan 2023 13:41:45 GMT https://community.qlik.com/t5/Insight-Advisor/Need-Help-with-looping-through-dates/m-p/2021762#M195 Or 2023-01-04T13:41:45Z