Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Check this as well
pls can you explain what is happening internally ?
How data is linked to time ? how evaluate helps here ? what exactly 1/12 means ?
can you post some application ?
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!
Class() function could be a solution
Regards
Marco
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.