How to convert same expression in set analysis.

[sona_sa]

Hi Team,

IF(NUM(FinCalculatedDate) = FLOOR(NUM(VCalculated_Date)) AND EmpStatus_Code = '3' and Leave_AbsenceDays = 0 ,Employee_Code)`

Regards,

QA

[CELAMBARASAN]

Hi,

     I think this is your need.

=Only({<FinCalculatedDate={$(=Date(VCalculated_Date))},EmpStatus_Code = {'3' },Leave_AbsenceDays = {0 }>} Employee_Code )

Hope it helps

Celambarasan

[sona_sa]

Hi Celambarasan,

But i want to use this expression in Dimension Part so ONLY will not be usefull.

My requirement is NOT to count Employees satisfying the avobe condition,But to list them out...

Thanks,

QA

[CELAMBARASAN]

Hi,

     Instead of restricting it in dimension part you can do it in the expression part.Is there any problem in doing it in expression part?

Celambarasan

[jagan]

Hi,

What are the Dimensions and expressions in your chart.  If you chart has any expression then use the Set analysis part of the expreesion and use Employee_Code as dimension.  The dimension is automatically filtered by the expression results.

Regards,

jagan.

[#6]

Hi Akumar,

Just enclosed Celambarasan's expression in AGGR() function.

Example:

AGGR(Only({<FinCalculatedDate={$(=Date(VCalculated_Date))},EmpStatus_Code = {'3' },Leave_AbsenceDays = {0 }>} Employee_Code ), Employee_Code)

Regards,

Ronald