Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

skebbell
New Contributor

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
terezagr
Contributor III

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

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.

shraddha_g
Honored Contributor III

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

Please check in base data.

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

skebbell
New Contributor

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

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

Community Browser