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

Count Active ID with master calendar

Hi everyone,

I need help to count active id on master calendar.

My expression is 

=Count({<EffectiveDate={'='>=' & $({Tipo={"hire"}>}EffectiveDate) '<=' & $({<Tipo={"terminate"}>}EffectiveDate)'}>}distinct ID)

pthai_0-1634629961536.png

My expected result is:

MonthYear Active ID
Jan-2015 1
Feb-2015 1
Mar-2015 1
Apr-2015 1
May-2015 1
Jun-2015 1
Jul-2015 2
Aug-2015 2
Sep-2015 2
Oct-2015 2
Nov-2015 2
Dec-2015 2
Jan-2016 2
Feb-2016 3
Mar-2016 3
Apr-2016 3
May-2016 3
Jun-2016 3
Jul-2016 3
Aug-2016 3
Sep-2016 3
Oct-2016 2
Nov-2016 2
Dec-2016 2
0 Replies