Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chris_soto
Contributor II
Contributor II

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?

Labels (1)
1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

thats quite straightforward

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

And give appropriate name

Capture.PNG

View solution in original post

7 Replies
dplr-rn
Partner - Master III
Partner - Master III

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
Contributor II
Contributor II
Author

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. 

dplr-rn
Partner - Master III
Partner - Master III

thats quite straightforward

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

And give appropriate name

Capture.PNG

chris_soto
Contributor II
Contributor II
Author

This worked, thank you for your help.

qliky88
Creator
Creator

hi @dplr-rn , using this method will Qlik Sense automatically update once changes have been saved in the network folder, or will someone have to attach and load the updated file to Qlik? 

Thanks 🙂 

dplr-rn
Partner - Master III
Partner - Master III

Do you mean changes to the file? If so qliksense will pick it next time it reloads.

 

If you mean changes to folder path. You will need to update the connection

Chris_1978
Contributor II
Contributor II

Hi 

I have uploaded a excel file via the QLIKsense data editor in the HUB. 

Who could I update the data in Qlik when the data is updated in the original excel file?

I've tried "Load data" 

Chris_1978_0-1614173038690.png

 

Thanks in advance

Chris