Update data file from excel files

[#1]

Hi everyone, please I will like to know how to connect my data files on Qlikview to excel so that each time I update the file on excel , it automatically updates on QV.

thanks in anticipation.

[jaimeaguilar]

Hi,

I think it doesn't work that way. You can load data from Excel files to QlikView. Then the way that data gets updated in your QlikView file depends on the reload task that you define for this QV File in Management Console,

regards

[kangaroomac]

Hi Olabisi,

You have a few options:

1. Update QV everytime you enter a value in XL
2. Have a frequent schedule running (i.e. every 10 odd minutes)
3. Put a button on XL that triggers a .bat file that does the upload (never tried it, but can't think why it wouldn't work)
4. Direct Discovery
   • You have some limitations on QV features you can use and also you need to either use a Custom Connector (bit like killing a mozzie with a canon in your case) or an ODBC / OLE DB Connection (not sure if a link table from Access to the XL file and then setting up that Access DB as a Data Source would work, but worth a try)
   • If you do decide to go down the Direct Discovery route, you may find this document useful: https://community.qlik.com/servlet/JiveServlet/previewBody/3710-102-2-6832/QlikView%2011%202%20Direc...

[#4]

Hi Ian,

I am actually facing the same issue as Olabisi.

I have an excel file that i would constantly be updating (sales file) and i would like that to update my charts (automatically preferably)

However, i am using Qlik Sense instead.

Thanks

Regards,

Zhennan