Link fields of two different table in set analysis

[#1]

Hello,

I have a Calendar table and a Attendance table. I am not linking the Calendardate and the Attendance date in the two tables. The two tables are not linked. Now I have a chart where I am taking CalMonth as dimension and I want sume of Hrs worked for that Cal Month.

The expression I have written is taking a lots of time., so I am trying to replace the if by using set analysis. I have written an expression as :

Count(Distinct {$<EmpStatus = {'A'}>}if(CalMonth=AttMonth and CalYear=AttYear,
if( Aggr(Sum({$<EmpStatus = {'A'},ATTWorkFlag = {'Working'}>} if(CalMonth=AttMonth and CalYear=AttYear,HrsWorkSecs)), EmpID,CalMonth,CalendarDate) >=
Aggr(Sum({$<EmpStatus = {'A'},WorkFlag = {'Working'}>} $(MinWorkHrsSecs)),

EmpID,

CalMonth)
,

EmpID)))

When I am trying to use set analysis its not giving me any output... Please help!!!

[#2]

Hi,

Try sth like that in your set:

{< ..... CalMonth = {$(=concat(AttMonth ',')} >}

assuming that CalMonth and AttMonth have the same key values

Fabrice

[#3]

Thanks for ur solution,

I tried like this., but its not giving any output....

{$<EmpStatus = {'A'},CalMonth = {"=AttMonth"},CalYear = {"=AttYear"}>}

[#4]

it is why you should use the concat function, to transfor the value into text

Fabrice

[#5]

Hello Fabrice,

Thanks for your help. But the Concat didnt work. Could you think of any other solution...