Time Band

[manojkulkarni]

Hi All

I am looking to create time bands in one of my applications to see when are our most busy periods of the day. I have got a date field that is associated to user field. . I am looking to create set time bands such as 9-10,10-11 and so on. so i can count the number of users in each time band. What would be the best way in QlikView to achieve this?

[Anonymous]

Hi,

Please have a look it may help you

10 min time interval

[Anonymous]

Check this as well

Creating Time Bands

[manojkulkarni]

pls can you explain what is happening internally ?

How data is linked to time ? how evaluate helps here ? what exactly 1/12 means ?

[manojkulkarni]

can you post some application ?

[Anonymous]

HI,

For example:

I have data with Date&Time field and corresponding Visits to it. I would like to plot a graph showing 30min trend.

e.g.

Time                         Visits

0600	1,004
0630	1,403
0700	1,987
0730	2,916
0800	3,063
0830	4,875
0900	6,356
0930	7,415
1000	6,454
1030	6,786
1100	8,298
1130	8,276
1200	9,074
1230	10,341

to get intervals like this we will use this logic, Per day 24 hours so here in this example we want each interval with 30 minutes. The calculation goes like this for 1 hour - 1/24, for 30 min. - 1/48, for 15 min. - 1/84 likewise as per your requirement it should be every one hour - 1/24.

Hope it will help!

[MarcoWedel]

Class() function could be a solution

Regards

Marco

[jagan]

Hi Manoj,

Try like this

Data:

LOAD

*,

Hour(DateTimeFieldName) & ' - ' & Hour(DateTimeFieldName) + 1 AS Timeband

FROM DataSource;

Now use Timeband field as dimension in your chart and Count(SomeID) as expression.

Regards,

Jagan.