Count ID's bewteen Dates

Seier-Alsenz — Tue, 05 Apr 2022 06:30:59 GMT

Hello,

I need your knowledge.

i have a list of employees with start date and end date (and much other master data). i would like to count how many employees i had at each point in time. in some cases i would like to query this differentiated by company or occupational group.

i have the basic question if this is solved in the best-practise in a SET-Analysis or by a script.

Currently this is solved in Excel and have built a large matrix at the monthly basis. It looks something like this solution:
https://community.qlik.com/t5/App-Development/Count-of-IDs-between-two-dates/m-p/1573531#M41792
Is a flag table (employees per month) getting too large? Or is this concern irrelevant?

Kind regards

Re: Count ID's bewteen Dates

Qbo — Thu, 07 Apr 2022 10:20:43 GMT

If you have a date calendar already setup you can intervalmatch() to the employee table and then just do a distinct count of employeeID's over the dates that you're after.

Few solutions here would work: https://community.qlik.com/t5/QlikView-App-Dev/Employees-HeadCount/m-p/1311662

topic Re: Count ID's bewteen Dates in App Development

Count ID's bewteen Dates

Re: Count ID's bewteen Dates