Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this
=Count({<DateTimeField = {"=Frac(DateTimeField) >= MakeTime(9) and Frac(DateTimeField) <= MakeTime(17)"}>} Items)
Try this
=Count({<DateTimeField = {"=Frac(DateTimeField) >= MakeTime(9) and Frac(DateTimeField) <= MakeTime(17)"}>} Items)