How can i get total employee by date hired?

[#1]

hi,

i want to get the number of employee by date hired, but only the employee hired in 2011, and 2012,

ex.

emp_code          datehired

emp123             january 21, 2011

emp124             january 20,2010

emp125             march 20,2005

emp126             december 5,2012

emp127             may 3,2011

emp128             may 17,2012

emp129             april 3,2006

emp130             feb 17,2008

emp131             october 16,2012

emp132             july 21,2012

...new to qlikview..

[its_anandrjs]

Hi,

Write a script like

=count(If ( Year(datehired) = 2011 and Year(datehired) = 2012, emp_code) )

write this code in any text box or in expression

Regards,

Anand

[#3]

Hi.

While loading the source, U can filter the year 2010,2011

Script:

Load emp_code

        ,datehired

From test.xlsx where wildmatch(Year(datehired),2010,2011)

and then u can write a expression like this in Chart

Dimension  = datehired

Expression = Count(emp_Code)

(Or)

U can simply write this expression in Chart..

Dimension  = datehired

Expression =Count({$<Year(datehired)={2010,2011}>} emp_code)

Regards,

Kabilan K.

[IAMDV]

Hi,

Please see the attachment and look at the List Box DV Output.

I hope this helps and please let us know if you need more.

Cheers,

DV

www.QlikShare.com