Date Problem

[Carlaf_93]

Good morning,

i've got something like this-.

load * inline [
Entrance_date,exit_date,id,
11/23/2023 10:00:00,11/23/2023 10:10:00,1

];

exit script;

i've would like to have a line graph that shows every minute how many people are inside the shop

[Or]

You would need to create a record for every minute to do this, I believe. Note that this may have a major impact on app size and performance.

Load id, Entrance_date+((IterNo()-1)/1440) as ByMinute From YourTable

While Entrance_date+((IterNo()-1)/1440) <= exit_date;

[MarcoWedel]

maybe helpful:

https://community.qlik.com/t5/Design/Creating-Reference-Dates-for-Intervals/ba-p/1463944

https://community.qlik.com/t5/Member-Articles/Generating-Missing-Data-In-QlikView/ta-p/1491394

https://community.qlik.com/t5/Member-Articles/Generating-Missing-Data-In-QlikView/ta-p/1491394?attac...