Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
mrtincho
New Contributor

Grouping data in a table by time intervals

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?

 

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Grouping data in a table by time intervals

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

talk is cheap, supply exceeds demand
Highlighted
mrtincho
New Contributor

Re: Grouping data in a table by time intervals

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?

 

Highlighted
MVP & Luminary
MVP & Luminary

Re: Grouping data in a table by time intervals


@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.

 


talk is cheap, supply exceeds demand