iteration to create registry

fkeuroglian — Wed, 16 Dec 2015 14:05:35 GMT

Hi Expert

I have a parking register and i have a time start and time end, for example i have that a car get into the parking at 7:00 am and get out at 9:30 am.

I want to create a iteration that create a regist for each time that the car is in the parking, for example in this case i will have 3 different register or lines, from 7 to 8, from 8 to 9 and from 9 to 10.

i want this because i want to count after the hours by separate.

and i want to know for example what is the numbers of cars that the parking have from 7 to 8 and from 8 to 9 for example.

i attached and image with the example and the qvw and qvd to show

i have to create an iteration usign for? or what would you reccomend to create this ?

thank you a lot

Fernando K.

Re: iteration to create registry

marcus_sommer — Wed, 16 Dec 2015 15:27:32 GMT

Such iteration could be done per while-loop - here Re: days between a date range an example with dates but with hours it will work, too - and you might need before a rounding-logic for the minutes.

- Marcus

topic iteration to create registry in QlikView

iteration to create registry

Re: iteration to create registry