Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
See why Qlik was recognized for the seventh year in a row – and discover how we can help you tackle your data integration challenges. Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
eannjones60
Contributor
Contributor

Sum for minute data by Hour

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?

3 Replies
Not applicable

Hi,

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

Rebeca

prodanov
Partner - Creator
Partner - Creator

View this application! View dimension!

jagan
Luminary Alumni
Luminary Alumni

Hi,

Please find attached file for solution.

Regards,

Jagan.