Less than or equal to Timestamp

Thu, 21 Feb 2013 22:29:33 GMT

I would like to use set analysis to show the # and % of timestamps that are <= to 00:10:00 (10 minutes)

TimeStamp

0:05:12

0:15:00

1:02:32

0:09:00

0:10:00

0:06:52

Thanks for your help

Mark

0:01:31

0:21:32

0:09:40

0:11:07

0:15:09

0:05:36

0:09:44

0:19:07

0:26:12

0:23:36

0:29:46

0:17:52

0:01:31

0:21:32

0:09:40

0:11:07

0:15:09

0:05:36

0:09:44

0:19:07

0:26:12

0:23:36

0:29:46

0:17:52

0:01:31

0:21:32

0:09:40

0:11:07

0:15:09

0:05:36

0:09:44

0:19:07

0:26:12

0:23:36

0:29:46

0:17:52

Re: Less than or equal to Timestamp

Thu, 21 Feb 2013 23:02:32 GMT

Try:

Count({<MyField = {"<=$(=Timestamp#('00:10:00'))"}>} MyField)

Re: Less than or equal to Timestamp

Thu, 21 Feb 2013 23:37:04 GMT

Thanks Juan

topic Less than or equal to Timestamp in QlikView

Less than or equal to Timestamp

Re: Less than or equal to Timestamp

Re: Less than or equal to Timestamp