topic Re: Restrict the Time in Set Analysis in App Development

Restrict the Time in Set Analysis

datashaw — Sat, 16 Nov 2024 06:01:25 GMT

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 — Tue, 23 Apr 2019 16:49:47 GMT

Try this

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

datashaw — Tue, 23 Apr 2019 17:05:59 GMT

Great Sunny 🙂 , Many thanks For your help.