Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Less than or equal to Timestamp

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
1 Solution

Accepted Solutions
Not applicable
Author

Try:

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

View solution in original post

2 Replies
Not applicable
Author

Try:

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

Not applicable
Author

Thanks Juan