Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
smobariki
Contributor
Contributor

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

@smobariki  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)

Plees ekskuse my Swenglish and or Norweglish spelling misstakes