Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks! Took some modifications for my purposes, but this was a great starting point.