2 Replies Latest reply: Apr 21, 2015 11:20 AM by Eveline van den Heuvel RSS

    Opening data from a file with date today

      Dear all,

       

      how do I get data from a file with date today in it?

       

      For example I would like to open C:\Desktop\test20150421.xlsx in Qlik Sense.

       

      Instead of using the code below, I would like to have something like

      FROM [lib://Desktop/test & Date(today(),'YYYYMMDD') & .xlsx] (ooxml, embedded labels, table is Sheet1);

       

      Table1:

      Load

          "Class 1",

          "Class 2",

          "Class 3",

          "Class 4"

      FROM [lib://Desktop/test20150421.xlsx] (ooxml, embedded labels, table is Sheet1);

       

      Please let me know if you know anything.