Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
I want to calculate the minute a second time duaration.
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