topic Re: Break times into specific intervals (15 mins) in QlikView

Break times into specific intervals (15 mins)

Wed, 25 Nov 2020 16:16:04 GMT

I have a data set with the following columns

* StatusStartTime

* UserID

* StatusName

I want to be able to break the StatusStartTime which can be anytime up to the second into 15 mins interval and do a count on Status Name.

For e.g I want to know in a specific 15 min interval how many agents were on the "Available" status.

Any help/suggestion on how I can go about doing that would be much appreciated.

Thanks,
Amit

Clever_Anjos — Wed, 16 Nov 2016 16:28:17 GMT

At load script create a field with

LOAD [otherfields]

StatusStartTime,

Floor(StatusStartTime,1/(24*4)) as StatusStartTimeGap

Wed, 16 Nov 2016 18:29:56 GMT

Thank you!