Discussion Board for collaboration related to QlikView App Development.
I want to use the input field to get the data from user and process the calculation. And more importantly i want to store the input for the future references.Does the same has to be done using Macros or is there anyother option for the same.
QlikView is not designed for writting back data to the database. To implement this, you have to manually create procedures to accomplish this or use budgeting tools (like Prophix) for write back.
It should be possible since in the Edit Script there is an option in Settings as Open Database in Read and Write Mode. So there should be some way to write back to the database either by macro or other way.
Ay experts who has idea on this ...........Please help.
You can run a Stored Procedure (attached) where you could send variables to write to the database, but usually we've just exported a flat file from QlikView to a folder and had the database run a job to save it to the database.