topic Re: counting active employee less than selected year in QlikView

counting active employee less than selected year

Fri, 20 Jul 2012 06:12:41 GMT

Dear Experts,

i have to count all the active employee from selected year till minimum year in the list.

guide me how i should do this i m new to qlikview.

Regards.

Tayyab

Fri, 20 Jul 2012 10:37:25 GMT

send some data sample (qvw )

MayilVahanan — Fri, 20 Jul 2012 12:45:40 GMT

Hi,

Try like this,

=Count({<Year = {'>=$(=Min({1}Year)) <= $(=Max(Year))'}>}Distinct Employees)

It gives count of distinct employees from selected year to minimum year in your list.

Hope it helps

Thu, 14 Feb 2013 11:02:13 GMT

if i want to use the same formula for the selected year ,month and day.

Thu, 14 Feb 2013 11:02:47 GMT

if i want to use the same formula for the selected year ,month and day.