3 Replies Latest reply: Mar 11, 2013 10:08 AM by Edward Hart RSS

    Organise Data Within Load For Calendar

      Hi,

       

      I currently have a dataset that I want to convert into a visual calendar within QlikView.  I beleive the best way to do this would be to set it up within a pivot table.  The problem that I have is the data itself and how to go about combining certain fields based upon the date and time.

       

      Example Raw Table:

      KeyDateDayActionTime
      111/03/2013MonVisit11am
      212/03/2013TueVisit10am
      313/03/2013WedVisit2pm
      414/03/2013ThurVisit3pm
      512/03/2013TueCall2pm
      612/03/2013TueCall4pm
      714/03/2013ThurCall10am

       

       

      What I want to get to:

      DateDayDetail
      11/03/2013MonVisit @ 11am
      12/03/2013TueVisit @10am  Call @ 2pm  Call @ 4pm
      13/03/2013WedVisit @ 2pm
      14/03/2013ThurCall @ 10am   Visit @ 3pm

       

      I have no idea how to do a field merge based upon a lookup.

       

       

      Can anyone help point me in the right direction?

       

       

      Many thanks