Looking for a solution

h0rh3 — Tue, 14 Feb 2023 21:02:05 GMT

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!

Re: Looking for a solution

h0rh3 — Wed, 15 Feb 2023 23:06:02 GMT

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.

topic Looking for a solution in QlikView

Looking for a solution

Re: Looking for a solution

Re: Looking for a solution