topic Grouping data in a table by time intervals in QlikView

Grouping data in a table by time intervals

mrtincho — Wed, 25 Nov 2020 16:16:04 GMT

I have a table that groups calls received in a shift center with date and time in unix time format. I was able through formulas, to extract year, date and time separately. What I want to do and can not do is a table that groups me the calls received by the hour (i wanted to do 24 intervals). For example:

Interval Count calls Seg call

00:00am a 01:00 am 5 1560

01:00 am a 02:00am 15 15560

Is there any way to do that?

Re: Grouping data in a table by time intervals

Gysbert_Wassenaar — Mon, 10 Jun 2019 15:58:39 GMT

Create an additional hour field from the time using the Hour() function.

Re: Grouping data in a table by time intervals

mrtincho — Mon, 10 Jun 2019 16:07:52 GMT

HI, ty for the answer but Had i table like this:

Hour Time call (sec)

01:15 am 15

01:27 am 25

I want to do a table like this

Interval Numbers call Time Call

00:00 a 01:00 0 0

01:00 a 02:00 2 40

etc.

Is it possible?

Re: Grouping data in a table by time intervals

Gysbert_Wassenaar — Tue, 11 Jun 2019 07:17:27 GMT

@mrtincho wrote:
I have a table that groups calls received in a shift center with date and time in unix time format. I was able through formulas, to extract year, date and time separately

Use the Hour() function to create an additional field with the hour of the time part of the unix timestamp.