2 Replies Latest reply: Apr 27, 2016 5:45 AM by Rendi Yanuar RSS

    [ASK] set analysis for latest location of a person based on period

    Rendi Yanuar

      Dear QlikView master,

       

      i have to count total person in each location based on person's latest location period (date_end).

      And every person have it's own period in each location.

       

      i create a straight table without set analysis, it shows like below :

      LocationDate_EndPersoncount(Person)
      A28/02/2012111
      B28/05/2015111
      C25/01/2014221
      D25/05/2015221
      E25/04/2016221
      F27/04/2016331

       

      And expected result shows like below :

      LocationDate_EndPersoncount(Person)
      B28/05/2015111
      E25/04/2016221
      F27/04/2016331

       

       

      How to create like result shows above?

       

       

      Thanks,

      Best Regards