Issue with getting the max(date) in set analysis

Mon, 09 May 2011 12:08:06 GMT

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

topic Issue with getting the max(date) in set analysis in QlikView

Issue with getting the max(date) in set analysis