Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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

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

3 Replies
Highlighted
Partner
Partner

It looks like you are not getting the updated data because your connection to the file is not correct.

Where do you store your updated .csv? Is it the same place like your referenced lib:?

To check if you are pointing to the right file go to Data Load Script - > Data connections and click on Selected data icon.

Highlighted
Partner
Partner

Please check in base data.

Also you can store data in qvd and and then use that qvd in final dashboard

Highlighted
Contributor II
Contributor II

Hi Tereza,

many thanks for that - yes I changed the location of the files and saved them on the Remote Desktop Connection for Qlik Sense Server: C:\Qlik\Files\My Folder and changed the location in the script:

[201605 Customers May 2016]:

LOAD [Customer_ID]

  ,[Customer Name]

    ,[Transaction Date] 

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

FROM [lib://My Folder 201605 HR Med.Group May 2016.csv]

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

This seems to work well now.

Thanks again,

Sarah