8 Replies Latest reply: Nov 28, 2012 4:38 PM by ben.daniel RSS

    Getting a Single Value from a One to Many Relationship

      StartDate
      HorizonDateBookings
      07/04/201207/01/201210
      07/04/201207/02/201211
      07/04/201207/03/201212
      07/04/201207/04/201214

       

       

      QlikView Community,

       

      I have a case when I am modeling a hotel.  People book up to the date of arrival as shown in the example above.  I need to write an expression that gets the the last line from my table above.  So that I can show the final number of bookings without displaying all the bookings?

       

      Can someone help me write this expression?

       

      Thanks,

       

      Ben