Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am interested in integrating QlikView Personal Edition with my desktop application. I have it mostly working, but I am concerned about the path to the Excel data being different on user machines.
I have a QlikView file I created (QlikDashboard.qvw) with the desired charts pre-configured. Currently my process looks like this:
I would like QlikView to display the pre-configured charts using the data in the new qlik.xls file, which will likely not be in the same location as the qlik.xls file used when I created QlikDashboard.qvw, but it WILL be in the same folder as QlikDashboard.qvw when I open it.
Can anyone point me in the right direction with regards to updating the excel data and potentially the .xls file path when opening a qvw file?
hi
if the files are in the same folder
make sure that in the load statement you only reference the file name
with out a path
Qlikview will no to search the file in the same folder
so anyone who has the files in the same folder will be able to load the qvw app
with no regard to the folder path
Thank you, Liron. I removed the path from the filename in the LOAD FROM statement, which solved my path issue. I am also launching qv.exe with the /l switch to load the data on startup.