Hi ,
I am developing an application, which shows the organization data . I am facing an issue trying to do this :
EmplId | TransferInDate | TransferOutDate |
001 | 1-Jan-11 | 15-Jan-11 |
001 | 3-Feb-11 | 17-Feb-11 |
001 | 23-Feb-11 | 30-Feb-11 |
Can we get for this employee Max(TransferInDate)<=30-Feb-2011 and Max(TransferOutDate)<= 30-Feb-2011 , in set analysis. In this case I need to get the third record. I am not able to do Max([TransInDt]) < {"<=$(=MAX(Date here))"} in set analysis. Its giving me error when trying to write the expression.
Is it feasible to write an expression like this in QlikView set analysis. For the selected period can we get max(TansInDt). Is there any other way to do this.
This is the expression I am using :
=Count(
{
$<
[Hire YearMonth] = {"<=$(=MAX(FullMonth))"},
[HADYearMonth] = {"<=$(=Year(MAX(Date + 3)) * 10000 + Month(MAX(Date + 3)) * 100 + Day(MAX(Date + 3)))"}
>
- <[no_accessed_project]={0}, //Upto here everything seems fine
Max([TransInYearMonth])={"<=$(=MAX(FullMonth))"} //Getting an error here
>
}
distinct EmplId
)
Please suggest.
Thanks,
Srihari