topic Time Interval Creation in Qlik Sense in App Development

Time Interval Creation in Qlik Sense

loganathan — Tue, 30 Nov 2021 16:25:32 GMT

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,

Re: Time Interval Creation in Qlik Sense

Vegar — Tue, 12 Oct 2021 04:31:32 GMT

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'))

Re: Time Interval Creation in Qlik Sense

loganathan — Tue, 12 Oct 2021 04:52:28 GMT

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

Re: Time Interval Creation in Qlik Sense

Vegar — Tue, 12 Oct 2021 17:40:33 GMT

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.