topic Re: active employee count in QlikView

active employee count

subbareddykm — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have one requirement, where i have to count Active on year basis.

But in my case , i have created year and month field in data . i ahve used year filter in dimentions and Expressiomn as Count(Emp)

It is giving me only Active employees in that year only but i want as of respective year.

but if create expression for every year wise and filter data field then it giving me correct and also later want create for Year wise month too.

How can i achieve this?

Re: active employee count

rahulpawarb — Mon, 27 Feb 2017 06:37:02 GMT

Hello Subbareddy,

Please refer below given draft expression:

//Considering Year dimension is used in filter
Count({<Year={"<= $(=Max(Year))"}>}Emp)

//Considering Year dimension is used in filter
//If you identify an employee is an active based on flag IsActive (1-Active/0-Inactive)
Count({<Year={"<= $(=Max(Year))"}, IsActive={'1'}>}Emp)

Hope this will be helpful.

Regards!

Rahul

Re: active employee count

silambarasan — Mon, 27 Feb 2017 06:46:42 GMT

How do you identify the active employee?

Re: active employee count

subbareddykm — Mon, 27 Feb 2017 06:55:32 GMT

I have a flag for it

Re: active employee count

silambarasan — Mon, 27 Feb 2017 06:57:18 GMT

count({<Flag={1}>}emp)

1 is active

0 is Inactive

Re: active employee count

subbareddykm — Mon, 27 Feb 2017 06:57:59 GMT

Its not working rahul,

its giving only for that year only.

Let me create sample data for it ,it will be helpful to work on it

Re: active employee count

rahulpawarb — Mon, 27 Feb 2017 06:59:56 GMT

Thank you If possible please share the application with sample data.

Re: active employee count

subbareddykm — Mon, 27 Feb 2017 07:03:37 GMT

Let me explain the scenario,

For example

now we are in 2017 year, If we check active Emp let say 1550.in this if i apply only active Filter then i will get only for 2017 but i want for <=today.

and if we are in 2016 , 2016 max date we have to consider and same like above.

i hope you understand.

Re: active employee count

ganeshsvm — Mon, 27 Feb 2017 07:10:25 GMT

Hi,

Providing sample data and your required result in Excel would be easy for us to evaluate the result for you.

-Ganesh

Re: active employee count

ajsjoshua — Mon, 27 Feb 2017 07:15:18 GMT

Hi,

Try this

Count({$<Date={"<= $(=Date(Max(Year)))"}, IsActive={'1'}>}Emp)
Count({<Date={"<= $(=Date(Max(Year)))"}>}Emp)

Re: active employee count

muthukumar77 — Mon, 27 Feb 2017 09:47:49 GMT

Hi,

Try this

Count({$<Date={"<= $(=Date(Max(Year)))"},Year=, IsActive={'1'}>}Emp)
Count({<Date={"<= $(=Date(Max(Year)))"},Year=>}Emp)