3 Replies Latest reply: Oct 20, 2016 6:53 AM by Sarah Kebbell RSS

    How to refresh Qlik Sense dashboard after manually changing underlying .csv file

    Sarah Kebbell

      Hi,

       

      I've created a dashboard and I've got a number of monthly files in the load statement, e.g. :

       

      [201605 Customers May 2016]:

      LOAD [Customer_ID]

        ,[Customer Name]

          ,[Transaction Date]  

         ,MonthName([Transaction Date]) as 'Transaction Month'

      FROM [lib://AttachedFiles/201605 Customers May 2016.csv]

      (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

       

      [201606 Customers June 2016]:

      LOAD [Customer_ID]

        ,[Customer Name]

          ,[Transaction Date]  

         ,MonthName([Transaction Date]) as 'Transaction Month'

      FROM [lib://AttachedFiles/201606 Customers June 2016.csv]

      (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

       

      Some dates were incorrect in one month, e.g. May, and I manually corrected them in the .csv file, but when I try and 'Load' them again using the Data Load Editor, the dashboard is not updating with the new data and maintaining the old file contents. How can I get it to point at the newer dataset?

       

      Many thanks,
      Sarah