topic Re: Taking count in hourly basis in QlikView

Taking count in hourly basis

Thu, 05 Jun 2014 16:51:35 GMT

i need to generate a table as i have shown in the image i need to break down the hours of the day from 00.00 hr - 24.00 how can i do this.. help in this would be really appreciated..

i need to show the particular counts according to each hour plz some one help me out in this .

thank you in advance

Re: Taking count in hourly basis

Thu, 05 Jun 2014 16:53:47 GMT

Is there anyway you could share your qvw? It is difficult to help without understanding your underlying data and how you are implementing this in your solution.

Re: Taking count in hourly basis

Thu, 05 Jun 2014 16:58:16 GMT

Something like =time(class(aggr(frac(YourTimeField),YourTimeField),1/24)) as your dimension should give you those hourly buckets I believe.

Re: Taking count in hourly basis

eduardo_sommer — Thu, 05 Jun 2014 17:02:27 GMT

If you create a field from the original datetime using the hour function, as in

Hour(DateTime) as Hour

this field will have a number from 0 to 23.

Create an inline table as in

HourTable:

Load Hour,

Hour&':00 - ' & Hour+1 & ':00' as HourInterval

inline [

Hour

];

Now you have the data associated with the Hour Interval you need.

Eduardo

Re: Taking count in hourly basis

Thu, 05 Jun 2014 17:11:23 GMT

Christian this actually worked but isn't there any of displayin the hours as 00.00- 01.00 , 01.00-02.00 etc ?? as its shown in the above table ??