4 Replies Latest reply: Feb 6, 2014 8:42 AM by Matthew Riedl RSS

    Import multiple sheets in excel

      I have an excel that creates a new sheet every week with data.

      So for the year 2013, I have every week a sheet with the name 2013-01, 2013-02 and so on.

       

      So the first difficulty is how to generate multiple sheets in Qlikview without creating a new load script for every sheet.

       

      The second problem is that I'm working with a crosstable with the date:

      ie underneath:

      CrossTable(Date, Amount, 2)

      Load

           Product,

           Supplier,

           [24/06/2013],

           [25/06/2013],

           [26/06/2013],

           [27/06/2013],

           [28/06/2013]

      From

      [..\File.xls]

      (biff, embedded labels, header is 1 lines, table is [2013-26]

       

      The problem here is that the dates also change every week.

      How can I implement these excels for the entire year of 2013?