Loop with time

[Anonymous]

Hi

I want to create a loop.

I have a start time and an end time of a task.

Now I want to check when the task is running.

For example, a task is running from 6.35 until 8.12

I want it detailed up to 15 minutes, this means it was running at

6.45

7.00

7.15

7.30

7.45

8.00

I was thinking of creating a loop with time:

For counter = 0:00:00 to 23:45:00 step 0:15:00

...

Next

But this seems not to work.

Do you have any suggestions?

Kindest regards

Johan

[anbu1984]

Tab:

Load *,Num(Time#(EndTm,'h.mm') - Time#(StrtTm,'h.mm'))*1440 as Diff Inline [

StrtTm,EndTm

6.15,8.12 ];

Final:

Load Interval(Time#(StrtTm,'h.mm')+Time#(15 * IterNo(),'mm')) Resident Tab

While Diff / ( 15 * IterNo() ) > 1

[#3]

hi Johan

Here are good tips

http://community.qlik.com/blogs/qlikviewdesignblog/2013/09/02/loops-in-the-script

best regards

Chris