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
sunny_talwar

What is the error you are getting?

Fia_Fiia
Contributor
Contributor
Author

Hello this is table populasi for formula, help me because the formulas still not work

Fia_Fiia
Contributor
Contributor
Author

see a attachment, this is my table population

sunny_talwar

What was the error message that you got?