https://community.qlik.com/t5/QlikView/Show-task-execution-time-within-a-specified-time-band/m-p/1582532#M443002 <P>I want to get a output table as attached here. First horizontal row shows some time intervals of 15 minutes.</P><P>second row will be merged cells for each task according to their start time and end time.</P><P>(e.g if the start time is 12.15 AM and end time is 12.25 AM, then the cells showing 00.00-00.15,00.15-0030 will be merged for that particular task.and value will be shown as the time difference of start time and end time.</P><P>I have Data set ,that contains <STRONG>date of task execution, task name, start time, end time, execution time.</STRONG></P><P>I have tried using intervalmatch(),interval() for defining the time frames.Bt not able to achieve this. Please advise</P><P>Any lead can be helpful.</P> Sat, 16 Nov 2024 20:49:48 GMT spandita 2024-11-16T20:49:48Z https://community.qlik.com/t5/QlikView/Show-task-execution-time-within-a-specified-time-band/m-p/1582532#M443002 <P>I want to get a output table as attached here. First horizontal row shows some time intervals of 15 minutes.</P><P>second row will be merged cells for each task according to their start time and end time.</P><P>(e.g if the start time is 12.15 AM and end time is 12.25 AM, then the cells showing 00.00-00.15,00.15-0030 will be merged for that particular task.and value will be shown as the time difference of start time and end time.</P><P>I have Data set ,that contains <STRONG>date of task execution, task name, start time, end time, execution time.</STRONG></P><P>I have tried using intervalmatch(),interval() for defining the time frames.Bt not able to achieve this. Please advise</P><P>Any lead can be helpful.</P> Sat, 16 Nov 2024 20:49:48 GMT https://community.qlik.com/t5/QlikView/Show-task-execution-time-within-a-specified-time-band/m-p/1582532#M443002 spandita 2024-11-16T20:49:48Z