Write Back to Database

[#1]

Hi,

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.

Regards,XXX

[#2]

Hi Experts ,

Need ur suggestions on the writing the data back to database.

Regards,XXX

[#3]

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.

Ramunas

[#4]

Hi Ramnuas,

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.

[pover]

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.

Regards.

[#6]

I am also very interested in this topic. My question is. Is there any chance that the described procedures would also work via the Ajax Browser Client?

Thanks in advance,

Gunnar

[garystrader]

Your best choice with the AJAX client is to create an extension object.

[#8]

Thanks Gary!

Are there perhaps any examples to illustrate this?

[Siva_Sankar]

http://www.citagus.com/citagus/blog/qlikview-writing-back-to-database/

[agomes1971]

Hi,

the most elegant solution:

SQL Writeback from QlikView extension object.

Hope it helps