topic Re: Problem in Time interval calculation in QlikView

Problem in Time interval calculation

koushik_btech20 — Tue, 29 Jul 2014 07:50:37 GMT

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.

Re: Problem in Time interval calculation

Tue, 29 Jul 2014 07:57:03 GMT

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

Re: Problem in Time interval calculation

Tue, 29 Jul 2014 07:57:46 GMT

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

Re: Problem in Time interval calculation

koushik_btech20 — Tue, 29 Jul 2014 08:39:00 GMT

I want to calculate the minute a second time duaration.

Re: Problem in Time interval calculation

Tue, 29 Jul 2014 09:08:18 GMT

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