Qlik Community

Qlik Sense App Development

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

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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