Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
chris_soto
New Contributor

Updating Data From Excel Spreadsheet

Hello, 

I'm creating an app to track our daily production and we are planning on having someone input the daily production goal each morning. I was hoping to have them enter in a spreadsheet, save the spreadsheet, then it updates in Qlik during the normal update schedule for this app. I've seen a lot of articles about attaching a file, but that seems like it's static data. Is there a way to create a connection to a spreadsheet like this? Or is there another solution?

1 Solution

Accepted Solutions
Partner
Partner

Re: Updating Data From Excel Spreadsheet

thats quite straightforward

Create Connection --> All Files --> Enter the network path

And give appropriate name

Capture.PNG

View solution in original post

4 Replies
Partner
Partner

Re: Updating Data From Excel Spreadsheet

No Completely clear on your requirement but from what i understood it seems like you need to create a connection to a folder (which would be a network drive or s3 or similar) and put the excel file there.

the user would update the excel on that shared location 

chris_soto
New Contributor

Re: Updating Data From Excel Spreadsheet

Correct, the excel file will be in a shared network folder for the user to update each morning and that's what I need to connect to. 

Partner
Partner

Re: Updating Data From Excel Spreadsheet

thats quite straightforward

Create Connection --> All Files --> Enter the network path

And give appropriate name

Capture.PNG

View solution in original post

chris_soto
New Contributor

Re: Updating Data From Excel Spreadsheet

This worked, thank you for your help.