Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
takama13
Contributor II
Contributor II

Count occurrences of a range time within a range dates

Hi all,

I would like to count the occurrences of a range time within a date range.

An example would be clearer :

withing below range :

Monday May, 27th - 12:00 and Thursday May, 30th - 18:00

I want to count how many times I find the range 22:00 - 06:00

So result should be : 3

 

I can't find the approach to do it.

Thanks

2 Replies
danilostochi
Creator II
Creator II

Hi, check this out.
https://community.qlik.com/t5/Qlik-Sense-App-Development/Count-values-in-an-interval-function/td-p/1...
+55(44) 9 9993-3605, WhatsApp
E-Mail or Skype - danilo16stochi@hotmail.com
takama13
Contributor II
Contributor II
Author

Thanks

That could be a good start but the difficulty in my case will be to compare a range of times to a range of dates.