Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My company decided to switch from Power BI to Qlik Sense and so far it's been a mess.
Our IT team hasn't been able to load our database to Qlik's servers correctly and my boss asked me to start working on local files instead.
I managed to create some dashboards, however I don't understand how to refresh the information in my app. I tried dragging the files again to replace the information but this just creates copies of the tables I already have and makes the app crash.
What's the correct way to replace an "In app" file?
You should be able to create a data connection (in the load script, if you have permissions) to a local folder on your machine and load files into the script via the data connection. This loads the data in with the filepath so whenever you reload the app it pulls from that file.
I do not recommend loading in files as 'in app' files and in fact, actually kind of wish you couldn't load data in that way, because they're basically a black hole and it's kind of impossible to get updated and you have to rewrite the script to point to updateable files.
TLDR; use the data connection to your local folder.
I prefer using script editor and 'folder data connection' in this situation.