topic Re: Count hourly activity of measure devices in QlikView

Count hourly activity of measure devices

Sun, 18 Oct 2015 10:52:43 GMT

Dear Qlik Experts,

I have timeserie of values produced by about 200 measure devices as a CSV file.

One record (row) looks like this: timestamp (YYYY.MM.DD hour:min:sec), deviceID, value

A devices is active during several hours per day. If the devices is active it sends a data packet every 20 -30 minutes.

Now I need a list or - better - a graph displaying the number of active devices per hour.

Date Hour DevicesSeen

...

2015-10-17 22 20 (= 20 different devices have sent a least 1 one data packet)

2015-10-17 23 25

2015-10-18 0 21

2015-10-18 1 18

...

Best regards & many thanks in advance

Wolfgang

Anonymous — Sun, 18 Oct 2015 13:19:35 GMT

How about using :

Dimernsion: Hour

Expression: Count ( distinct [deviceID] )

MarcoWedel — Sun, 18 Oct 2015 22:49:46 GMT

Hi,

another solution could be a calculated dimension like:

Timestamp(Floor(yourtimestampfield,'01:00:00'),'YYYY.MM.DD hh')

hope this helps

regards

Marco