topic Re: Sum for minute data by Hour in QlikView

Sum for minute data by Hour

eannjones60 — Wed, 19 Jun 2013 14:02:27 GMT

I've got data which is s follows

(Date/Time) (qty)

16/05/13 09:19:18 10

16/05/13 09:20:03 3

16/05/13 09:20:29 25

16/05/13 09:20:30 40

16/05/13 10:10:05 25

16/05/13 10:11:26 30

16/05/13 10:15:30 14

16/05/13 10:21:10 5 etc by day for 18hrs a day

I need to do a sum of the 'qty' by date/hour. So, I need 2 sums on the above data, one for 16/05/13 09* and 16/05/13 10* and then onwards through the day. Is this possible?

Re: Sum for minute data by Hour

Wed, 19 Jun 2013 14:27:35 GMT

Hi,

Try the function hour() and make the size by day and time.

Rebeca

Re: Sum for minute data by Hour

prodanov — Wed, 19 Jun 2013 14:28:28 GMT

View this application! View dimension!

Re: Sum for minute data by Hour

jagan — Wed, 19 Jun 2013 14:46:55 GMT

Hi,

Please find attached file for solution.

Regards,

Jagan.