topic Re: count of time field in QlikView

count of time field

Mon, 10 Jun 2013 10:01:47 GMT

Hi,

I have a time field (hh:mm:ss) in a field called update_time_JD_1. What I am looking to do is create an expression that counts the data that is over 10 hours but I do not want it to count the data over 20 hours.

E.G.

00:00:05

00:10:05

05:10:09

10:10:10

13:16:19

20:02:30

This would show the count as 2, as I want it to show the 10:10:10 and 13:16:19, but not the 20:02:30 (even though its over 10 hours).

Regards,

Jon Ditchfield

Re: count of time field

Mon, 10 Jun 2013 10:11:20 GMT

try this :

=count(if(time(TIME,'hh,mm,ss') > time('10:00:00','hh,mm,ss') AND time(TIME,'hh,mm,ss') < time('20:00:00','hh,mm,ss'), TIME))

Re: count of time field

er_mohit — Mon, 10 Jun 2013 10:16:32 GMT

Try this

Test:

LOAD * Inline [

Time

00:00:05

00:10:05

05:10:09

10:10:10

13:16:19

20:02:30

]Where time(Time,'hh:mm:ss')>'10:00:00' and time(Time,'hh:mm:ss')<'20:00:00' ;