Problem in Time interval calculation

[koushik_btech20]

I am new in Qlikview and facing a problem regarding the calculation of Time Interval. A excel data and a app(qvw) has been attached. Please share any idea.

[#2]

Hi Koushik

Can you define your exact problem?!

In case you want to generate time intervals of your event use the following:

Time(Hour([TimeField])&':'& (Minute([TimeField]) - Mod(Minute([TimeField]), 5)), 'HH:mm') as [TimeInterval5Min]

This will give you 5 Minute Intervals. If you want 20, 30 Min etc. just replace the "5" with your desired number.

Kind regards,

Anthony

[#3]

hi koushik

please explain it more what do you want to do.

Use can try interval match function to do calculation with help of inline table.

Thanks

Nitish Bansal

[koushik_btech20]

I want to calculate the minute a second time duaration.

[#5]

Hi Koushik

According to your sample i only see 1 field with a timestamp. In order to calculate a duration you need at least 2 fields...

I thought you want to show your events on a timeline of intervals?!

If so, please use my formula above.

Otherwise i don't get your problem...

brgds,

Anthony