topic How to convert same expression in set analysis. in QlikView

How to convert same expression in set analysis.

sona_sa — Mon, 20 Feb 2012 05:46:11 GMT

Hi Team,

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

Regards,

How to convert same expression in set analysis.

CELAMBARASAN — Mon, 20 Feb 2012 06:37:31 GMT

Hi,

I think this is your need.

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

Hope it helps

Celambarasan

How to convert same expression in set analysis.

sona_sa — Mon, 20 Feb 2012 06:50:06 GMT

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,

How to convert same expression in set analysis.

CELAMBARASAN — Mon, 20 Feb 2012 06:54:49 GMT

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

How to convert same expression in set analysis.

jagan — Mon, 20 Feb 2012 07:55:02 GMT

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.

How to convert same expression in set analysis.

Mon, 20 Feb 2012 08:08:51 GMT

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