Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to count records that their entry time is higher than 06:00:00 and less that 16:00:00 but i am not getting any success.
Each record comes from a database with a field name Dated in the format of Datetime.
I tried using the following expression but did not work on Qlikview or Qliksense:
=Count({$<Dated={">06:00:00"}, Dated={">16:00:00"}>}Id)
Could It be related to the datetime field format?
Any help.
Thanks in advanced.
May be this
=Count({$<Dated = {">06:00:00<16:00:00"}>} Id)