Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Fia_Fiia
Contributor
Contributor

How to Calculate Total Population Employe in every month

Hi,

Please Help me, I want search total population employee with, but how can I make the name of the new employee in the following month not appear so that every time I choose a month, the population will appear that month, this formula that I use but is not yet valid

=Count(DISTINCT{<year = ,month = ,status = ,MQ = ,Product = ,[Employee Status]={'*'}-{'Non Active'} >}Populasi)

this is a formula that only raises employees not logged in that month and for the next new employee it still appears. how to prevent new employees from appearing next month. Take my example in February but new employees in March and April also appeared:

=Count(DISTINCT{<year = ,month = ,status = ,MQ = ,Product = ,[Employee Status]={'*'}-{'Non Active'}>}Populasi)-count(DISTINCT idnumber_fto)

Thank you

13 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Can you provide a sample app that shows what is the current result shown in the expression vs the expected result that should be displayed?
Fia_Fiia
Contributor
Contributor
Author

Hello, This is what I want expected result 😊

Surya
Creator II
Creator II

Hello.,

Take stright table and 

diemsion As Month and

Expression as Count of emp

 

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Do you have the join date detail in your table?

Fia_Fiia
Contributor
Contributor
Author

Spoiler
Yes, I have
Fia_Fiia
Contributor
Contributor
Author

Allready, but the new emp id still calculate

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Can you please populate the join date detail into the sample excel as well?

sunny_talwar

May be this

=Count(DISTINCT{<year, month = {"<=$(=Max(month))"}, status, MQ, Product,[Employee Status] = {'*'}-{'Non Active'}>} Populasi) - Count(DISTINCT idnumber_fto)

Here I am assuming that month is defined as a number in your script based on the sample provided

 Capture.PNG

Fia_Fiia
Contributor
Contributor
Author

Still not work and error ....  🤔