0 Replies Latest reply: May 9, 2011 8:15 AM by sriharithakkilapati RSS

    Issue with getting the max(date) in set analysis

      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