Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
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
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.
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