Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Write Back to Database

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

10 Replies
Highlighted
Not applicable

Hi Experts ,

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

Regards,XXX

Highlighted
Not applicable

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

Highlighted
Not applicable

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.

Highlighted
Luminary
Luminary

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.

Highlighted
Not applicable

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

Highlighted
Partner
Partner

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

Highlighted
Not applicable

Thanks Gary!

Are there perhaps any examples to illustrate this?

Highlighted
Highlighted
Specialist II
Specialist II

Hi,

the most elegant solution:

SQL Writeback from QlikView extension object.

Hope it helps