Discussion board where members can get started with Qlik Sense.
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
There would be a column that counts
May 7th : 0
May 8th: 1
May 9th 1
May 10th :1
May 11th 0
How difficult would it be to setup something like this in Qlik? Is it possible?
Thanks for your time.
look at this first :
Intervalmatch example – with dates
and plenty of examples in forum with IntervalMatch
Also please refer this Using IntervalMatch()