Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
subbareddykm
Creator II
Creator II

active employee count

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?

10 Replies
muthukumar77
Partner - Creator III
Partner - Creator III

Hi,

Try this

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