Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Restrict the Time in Set Analysis

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.

 

 

Labels (1)
2 Solutions

Accepted Solutions
Highlighted

Re: Restrict the Time in Set Analysis

Try this

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

View solution in original post

Highlighted
Contributor III
Contributor III

Re: Restrict the Time in Set Analysis

Great Sunny 🙂 , Many thanks For your help.

View solution in original post

2 Replies
Highlighted

Re: Restrict the Time in Set Analysis

Try this

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

View solution in original post

Highlighted
Contributor III
Contributor III

Re: Restrict the Time in Set Analysis

Great Sunny 🙂 , Many thanks For your help.

View solution in original post