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)











      (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?