Time Interval Creation in Qlik Sense

[loganathan]

Hi All,

i am trying to achieve below result from the attached data. but my time interval is not working fine. Can anyone help to achieve this. 'Time Interval' is calculated the time values between 'Time Start' and 'Time Stop'.

Time interval	# of Items
7-8	19
8-9	30
9-10	20
10-11	17

Thanks in advance,

[Vegar]

if your interval is not created  correctly,  then it could be an issue with the interpretation of your time fields. Try this:

interval(time#([Time Stop],'hh:mm')-time#([Time Start],'hh:mm'))

[loganathan]

Hi Vegar,

thanks for your reply. I am using the below format

INTERVAL((Time#(Time([Time  Stop], 'hh:mm'),'hh:mm')- Time#(Time("Time  Start", 'hh:mm'),'hh:mm')) ,'mm') AS Interval,

still all the time interval is not properly calculating. Please advise

[Vegar]

I think you have swapped the intepret time#() with the formating time() function. Try this:

INTERVAL( (Time(Time#([Time  Stop], 'hh:mm'),'hh:mm')- Time(Time#("Time  Start", 'hh:mm'),'hh:mm')) ,'mm') AS Interval,

OR just remove the Time() formating function, since you are going to reformat it to an interval.

INTERVAL( (Time#([Time  Stop], 'hh:mm')- Time#("Time  Start", 'hh:mm')) ,'mm') AS Interval,

If you still have issues with the calculation then please provide an sample/example in order for us to help you further.