Count Time Instances

leobhavin — Sat, 18 Feb 2017 21:27:02 GMT

I am trying to count the number of instances where the time stamp minutes = 00, 15, 30, or 45. For example:

Time Stamp = DD/MM/YYYY hh:mm:ss

02/01/2016 09:45:00

03/01/2016 04:32:00

04/01/2016 10:15:00

05/01/2016

and so on....

For the above the count is 2. I am using Qlik Sense 3.1

My date and time are together. Note there are some instances where there is no timestamp but only date like in the example above.

Please could someone assist.

Re: Count Time Instances

vinieme12 — Sun, 19 Feb 2017 06:56:24 GMT

Separate out the minute factor during load to simplify the expression

timestmp:

Load timestamp#(TmStmp,'DD/MM/YYYY hh:mm:ss') as TmStmp,Minute(timestamp#(TmStmp,'DD/MM/YYYY hh:mm:ss')) as MinuteIS inline [

TmStmp

02/01/2016 09:45:00

03/01/2016 04:32:00

04/01/2016 10:15:00

];

in chart use expression like

=count({<MinuteIS={'15','30','45'}>}MinuteIS)