Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.