Restrict the Time in Set Analysis

[datashaw]

Dear Experts,

I'm trying to restrict the TIME using Set analysis in QlikSense Straight table. 

Requirement: Count of Items during 9 am to 5pm,  Field name = DateTimeField  and Format = DD/MM/YYYY hh:mm:ss

Please correct me the below expression-

=Count ( {<Time(Frac(DateTimeField) )={'>=09:00:00<=17:00:00' } >} Items)

I do not have  access to  create a variable in Edit script  to trim Time from the DateTimeField. All I need to show on front end UI level only..

please suggest me the solution.

[sunny_talwar · Accepted solution]

Try this

=Count({<DateTimeField = {"=Frac(DateTimeField) >= MakeTime(9) and Frac(DateTimeField) <= MakeTime(17)"}>} Items)

[datashaw · Accepted solution]

Great Sunny 🙂 , Many thanks For your help.