Looking for a solution

[h0rh3]

Hi,

I'm really new to the qlik community 🙂 Just trying to seek some help. Forgive me if I post this in a wrong forum or topic.

I have a data set similar to the table below. 

Month	Person	Active Date	End Date	TransactionID
Feb-23	Person1	12/01/2022	12/31/2999	123
Feb-23	Person1	12/01/2022	12/31/2999	123-a
Feb-23	Person2	12/01/2022	12/31/2999	456
Feb-23	Person3	/01/2023	12/31/2999	789
Jan-23	Person1	12/01/2022	12/31/2999	777
Jan-23	Person3	01/01/2023	12/31/2999	222
Dec-22	Person1	12/01/2022	12/31/2999	333
Dec-22	Person2	12/01/2022	12/31/2999	444

What I'm looking to do is have a chart that will show the count of distinct active 'Person' on a monthly basis based on their active date. A few things to consider are:

1. Just like Person1, they can have multiple transaction for the month

2. Person2 does not have data in Jan-23 but still should be counted as active.

Month	Active Employees
Feb-23	3
Jan-23	3
Dec-22	2

Thanks in advance!

[MarcoWedel · Accepted solution]

maybe helpful:

https://community.qlik.com/t5/Design/Creating-Reference-Dates-for-Intervals/ba-p/1463944

https://community.qlik.com/t5/Design/How-to-populate-a-sparsely-populated-field/ba-p/1470637

[h0rh3]

Thanks for this! I ended up using a loop 👍🏼 I spent some time figuring it out using set analysis but yeah, using loop is a straight forward solution.