Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am desperately trying to fight my way through creating a new dashboard and have come across a show stopping problem which, after 3 or 4 days of searching, I just cannot find any help on. I am successfully importing data from Excel files, which are stored in a folder on my hard disk by dragging and dropping them in the data load screen, however I cannot point the script to these files. I want to be in the situation where I can save new source data, overwriting the existing files, and then simply click "reload" in the dashboard, and see the new data. Can anyone please advise what I am missing, and obviously what extra information you need.
I am using a qliksense cloud based dashboard as I think I can do this in the desktop, but keep receiving warnings the desktop version is ceasing to be used.
Many Thanks in advance, Paul
Set up data connection that points to this path and file. Then LIB CONNECT to that.
You should be able to set up a folder data connection and then reference that data connection in your script.
LIB CONNECT TO 'DataSource';
where DataSource is the connection you created.
Thank you very much for taking the time to reply. In its simplest form, is this what I should be trying to do?
LIB CONNECT TO 'C:\Temp\qryExoport.xlsx';
LOAD .....
FROM [lib:qryExport.xlsx]
I am so sorry, I really appreciate your help, I am just struggling to find any meaningful help on this.
Set up data connection that points to this path and file. Then LIB CONNECT to that.