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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
mithunjacob
Partner - Contributor II
Partner - Contributor II
‎2018-11-26 11:12 AM

overlapping times and dividing into subintervals

Hi All,

I am trying to find overlapping times and divide into subintervals. This topic has been discussed here many times but I am not able to achieve in below scenario. I referred to the link - https://community.qlik.com/t5/QlikView-App-Development/Intervals-and-segmentation/td-p/421707  and achieved my requirement for one Detail Uid (attached excel - Time Overlap).

However, while using many Detail Uids, the logic is not working. Please let me know if anyone has solution.

I have attached a sample output for Detail Uid - 2171400. I am trying to get similar data for all the excel rows along with 'Detail Uid' and 'Crane Code' column in the attached screenshot

 

Labels (1)
Labels
Preview file
20 KB
418 Views
0 Likes
0 Replies