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

    Excel to QlikFriendly Format


      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 !