4 Replies Latest reply: Sep 29, 2011 7:20 AM by Anne Duffy RSS

    Excel to QlikFriendly Format

      QlikStaff.bmp

      Hi Guys,

       

      The above is a screen dump of an Excel log that we wish to load into Qlikview.

      Each Column is a Staff member and depending on whats populated into the cell on a particular date determines whether they are on Holidays (H) or in work (Null)

      When I load this into Qlikview , the fields are now the list of staff names. I wish to have a Staff Name Field and a date field , I believe the below format is a more prudent load. Is it possible to amend the data within the load , or do I need to fix the Spreadsheet prior ?

       

      Any help or thoughts on this , would be greatly appreciated !!! It looks like a big job me thinks !

      Thanks

       

      Qlikstaff2.bmp