Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jbakerstull
Creator
Creator

Count each daily instance within date range

I'm very new to qlik. My goal is to create a sheet that count's every person on a daily instance within a date range.


An example would: Report period : 5/1/2018 - 5/31/2018.


A person has a service that starts on 5/8/2018 through 5/10/2018.  Reenters on May 12th through 13th.


The table would listed the days of the separately month

May 1st

May 2nd

May 3rd

May 4th

etc,,

May 31st


There would be a column that counts


May 7th : 0

May 8th: 1

May 9th 1

May 10th :1

May 11th 0

May:12th: 1

May 13th:1

May 14th:0


How difficult would it be to setup something like this in Qlik?  Is it possible?


Thanks for your time.

  

2 Replies
ogautier62
Specialist II
Specialist II

Hi,

look at this first :

Intervalmatch example – with dates

and plenty of examples in forum with IntervalMatch

regards

vikasmahajan

Also please refer this Using IntervalMatch()

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.