SET ANALYSIS With COUNT to have o subquery in a year
I use QLIK SENSE Server in Windows with the version February 2023 Patch 5.
I need to calculate an indicator allowing to know the number of people present over a whole period without interruption. For this, I used a SET ANALYSIS to calculate for each employee (key KEY_SALARIE) how many months over the year they are present out of the 12 expected. I then count the distinct number of people only for those who are 12/12 months old.
This unfortunately doesn't work. Indeed, some employees who are present only 10 months or 11 months are wrongly counted and I do not understand why because when I select this person, the result of my indicator puts 0. But without employee selection, the value of the same KPI for the same person is 1.
The variables : $(v_SET_Y) -> Take all periode of the year even if they are a selection of a month.
$(v_SET_M) -> Take the last month in the period to count the person in this month
$(v_SET_Contrats_CDI) -> Take only types of contract