I am new to Qlik Sense. I'd appreciate it if anyone could let me know how to write a dynamic headcount measure in Qlik Sense. I was able to do it using the employee database with the information of hiring date and leaving date and was able to obtain the headcount at any point in time with the disconnected table using Power BI; and I tried to recreate the same headcount measure in Qlik Sense, but I have been unsuccessful so far. I'd appreciate it if anyone could share with me a standard headcount measure which is able to produce dynamic calculation at any point in time from the calendar table. (I am not interested in inflexible one where I have to indicate in the loaded data if the person is employed at one point in time which I sometimes see in an headcount dashboard example, as this will not be able to generate dynamic result based on the selected point in time). Thanks a lot for your help.
This post is interesting as I encounter the same problem in real life all the time with sales rep's customers they are in charge of slowly changing and having to deal with dimension table with time dimension component to it However, for the headcount measure, which I am using the employee table as a transaction table, instead of dimension table, this technique does not seem to apply. But thanks for the idea.