topic Re: Time Band in QlikView

Time Band

manojkulkarni — Thu, 27 Aug 2015 01:28:16 GMT

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?

Re: Time Band

Anonymous — Thu, 27 Aug 2015 01:50:15 GMT

Hi,

Please have a look it may help you

10 min time interval

Re: Time Band

Anonymous — Thu, 27 Aug 2015 01:52:06 GMT

Check this as well

Creating Time Bands

Re: Time Band

manojkulkarni — Thu, 27 Aug 2015 04:47:13 GMT

pls can you explain what is happening internally ?

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

Re: Time Band

manojkulkarni — Thu, 27 Aug 2015 06:29:03 GMT

can you post some application ?

Re: Time Band

Anonymous — Thu, 27 Aug 2015 16:08:56 GMT

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!

Re: Time Band

MarcoWedel — Thu, 27 Aug 2015 16:28:33 GMT

Class() function could be a solution

Regards

Marco

Re: Time Band

jagan — Fri, 28 Aug 2015 01:58:32 GMT

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.