Write back to database
It might take some time to find out how to write back in a database from Qlikview, so here’s my input.
In the script, create a connection to the database you want to work with:
We can then create a Insert statement to test if it works:
If we load the script, we’ll see the following error message:
This error message is basically telling as that the connection to the database is opened as read only. In order to make a Read/Write connection, we add “mode is write” in the connection statement and in the Settings tab in the Script Editor, we check options “Open Databases in Read and Write mode” and “Can Execute External Programs” although is not mandatory.
Now reload the application and you will be able to write back to the database.