Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
fkeuroglian
Partner - Master
Partner - Master

iteration to create registry

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.

1 Reply
marcus_sommer

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