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: 
Sharbel
Contributor III
Contributor III

count

Hi,

I want to count how many visits took place between 07:00 - 15:00 

I have been using the following expression :

=Count({$<Time={">=07:00<=15:00)"}>} Visit)

but it keeps coming up with all the visit and not just between 07:00-15:00

Thanks,

Sharbel

 

 

 

2 Replies
Kushal_Chawda

@Sharbel  Make sure that the Time input format matches with actual time format of field. Also, check that your time field is in proper time format.

If your time column values are in hh:mm format then try setting below variable in same format and reload your app

SET TimeFormat='hh:mm';

 

Vegar
MVP
MVP

You have an left parenthesis in your expression that you might need to remove. Right after the <=15:00.

=Count({$<Time={">=07:00<=15:00"}>} Visit)

I'm also concerned if your expression will interpret your modifier values as time values.

You might  need to adjust it to 

=Count({$<Time={">='07:00'<='15:00'"}>} Visit)

OR 

=Count({$<Time={">=$(=maketime(7))<=$(=maketime(15))"}>} Visit)