Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jgarciaf106
Creator
Creator

How to count records when the entry time is higher that specific time?

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.

1 Reply
sunny_talwar

May be this

=Count({$<Dated = {">06:00:00<16:00:00"}>} Id)