topic How to loop through records in QlikView https://community.qlik.com/t5/QlikView/How-to-loop-through-records/m-p/216049#M713667 <HTML><HEAD></HEAD><BODY><P>I would suggest a different approach. Generate a table of each minute and IntervalMatch that table with your fact table.</P><P>-Rob</P></BODY></HTML> Tue, 06 Jul 2010 23:09:25 GMT rwunderlich 2010-07-06T23:09:25Z How to loop through records https://community.qlik.com/t5/QlikView/How-to-loop-through-records/m-p/216048#M713665 <HTML><HEAD></HEAD><BODY><P>I have start time (2010-07-06 13:03:07) and End time ( 2010-07-06 16:24:39) for each record</P><P>I need to find by minute if the record was active or not and display to user in the table format.</P><P>13:00- 14:00 - Active Record</P><P>14:00-15:00 - Active Record</P><P>15:00 - 16:00 - Active Record</P><P>In general, how do I loop through a record and create a table by each minute.</P><P>Any help would be appreciated.</P><P></P></BODY></HTML> Tue, 06 Jul 2010 20:30:23 GMT https://community.qlik.com/t5/QlikView/How-to-loop-through-records/m-p/216048#M713665 2010-07-06T20:30:23Z How to loop through records https://community.qlik.com/t5/QlikView/How-to-loop-through-records/m-p/216049#M713667 <HTML><HEAD></HEAD><BODY><P>I would suggest a different approach. Generate a table of each minute and IntervalMatch that table with your fact table.</P><P>-Rob</P></BODY></HTML> Tue, 06 Jul 2010 23:09:25 GMT https://community.qlik.com/t5/QlikView/How-to-loop-through-records/m-p/216049#M713667 rwunderlich 2010-07-06T23:09:25Z How to loop through records https://community.qlik.com/t5/QlikView/How-to-loop-through-records/m-p/216050#M713669 <HTML><HEAD></HEAD><BODY><P>Thank you Rob for the direction . This worked.</P><P>Pranita</P></BODY></HTML> Fri, 30 Jul 2010 16:32:52 GMT https://community.qlik.com/t5/QlikView/How-to-loop-through-records/m-p/216050#M713669 2010-07-30T16:32:52Z