Discussion Board for collaboration on QlikView Scripting.
I have start time (2010-07-06 13:03:07) and End time ( 2010-07-06 16:24:39) for each record
I need to find by minute if the record was active or not and display to user in the table format.
13:00- 14:00 - Active Record
14:00-15:00 - Active Record
15:00 - 16:00 - Active Record
In general, how do I loop through a record and create a table by each minute.
Any help would be appreciated.
Go to Solution.
I would suggest a different approach. Generate a table of each minute and IntervalMatch that table with your fact table.
Thank you Rob for the direction . This worked.