topic Start to End Spanning Dates in App Development

Start to End Spanning Dates

cfountain72 — Tue, 30 Nov 2021 16:25:32 GMT

Good Morning,

I think this can be done in SQL, but I was wondering if any Qlik magic can accomplish the same. We are tracking different timeframes that need to be broken up across their separate dates. For instance:

Start Date: 11/1/2021 @ 10PM to End Date: 11/3/2021 @ 3AM

We would want to end up with three rows for this timeframe, showing the hours in each day:

11/1/2021: 2 (10PM to midnight)

11/2/2021: 24 (the whole day)

11/3/2021: 3 (midnight to 3AM)

Thanks in advance for any suggestions,

Chris

Re: Start to End Spanning Dates

MarcoWedel — Fri, 19 Nov 2021 17:05:54 GMT

Maybe helpful:
https://community.qlik.com/t5/QlikView-App-Dev/Split-duration-time-into-seperate-records-per-date/td-p/930757

Re: Start to End Spanning Dates

cfountain72 — Tue, 23 Nov 2021 14:20:27 GMT

Thanks! Took some modifications for my purposes, but this was a great starting point.