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
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.
Separate out the minute factor during load to simplify the expression
Load timestamp#(TmStmp,'DD/MM/YYYY hh:mm:ss') as TmStmp,Minute(timestamp#(TmStmp,'DD/MM/YYYY hh:mm:ss')) as MinuteIS inline [
in chart use expression like