Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to loop through records

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.

Tags (1)
1 Solution

Accepted Solutions

How to loop through records

I would suggest a different approach. Generate a table of each minute and IntervalMatch that table with your fact table.

-Rob

2 Replies

How to loop through records

I would suggest a different approach. Generate a table of each minute and IntervalMatch that table with your fact table.

-Rob

Not applicable

How to loop through records

Thank you Rob for the direction . This worked.

Pranita

Community Browser