Employees getting appraisal for true in continous 3 years.

[sona_sa]

Hi,

I have 4 Years of data for Employees with the field of Apraisal = 'True' and 'False'.

Now I want to check out who are the employees getting appraisal  for 'TRUE' in cotinuous 3 Years.

How we can do it ?

For example : I am sending some data in xls and QVW, So please find the attached file.

Regards,

A Kumar

[CELAMBARASAN]

Hi,

     Try with this,

Appraisal:

LOAD Year,

     Employee,

     Grade,

     Apprasial,

     If(Apprasial='TRUE',1,0) as AppraisalStatus

FROM

[Apraisail1.xls]

(biff, embedded labels, table is Sheet1$);

Create a chart with employee as dimension and below as expression

=If(Sum({<Year={">=$(=Max(Year)-2)<=$(=Max(Year))"}>} AppraisalStatus)>3,1)

Hope it helps

Celambarasan

[sona_sa]

Hi Celambarasan,

Thanks for reply,

As per provided expression, It is giving continuous of same year of the employee is getting appraisal. Like that for employee code = 18 is getting appraisal in 2008 and 2011 three times.

But I want employee who is getting the appraisal continuously yearwise, like - 2008 ->2009->2010 or 2009->2010->2011.

Again thanks for reply.

Regards,

A Kumar

[CELAMBARASAN · Accepted solution]

Hi,

     Then load your data as it is like

Appraisal:

LOAD Year,

     Employee,

     Grade,

     Apprasial

FROM

[Apraisail1.xls]

(biff, embedded labels, table is Sheet1$);

Create a chart with employee as dimension and below as expression

=If(Count({<Year={">=$(=Max(Year)-2)<=$(=Max(Year)))"},Apprasial={'TRUE'}>} DISTINCT Year)=3,1)

Is this your need?

Celambarasan

[sona_sa]

Thanks This one is correct.

Thanks a lot.

[#6]

I'm trying to do exactly the same, but within the script to finally

have a list box to decide selction "continues 3 years" and "not".

Can anybody help me with this?