Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
cfountain72
Contributor III
Contributor III

Start to End Spanning Dates

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

Labels (1)
1 Solution
2 Replies
cfountain72
Contributor III
Contributor III
Author

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