topic Re: Loop with time in QlikView

Loop with time

Anonymous — Wed, 14 May 2014 12:08:31 GMT

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

...

But this seems not to work.

Do you have any suggestions?

Kindest regards

Johan

anbu1984 — Wed, 14 May 2014 14:17:50 GMT

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

Wed, 14 May 2014 14:31:01 GMT

hi Johan

Here are good tips

best regards

Chris