Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Writing on a SQL database from QV

Hi,

QV reads from a SQL Server database but is it possible to write on a db? How? Is there a sample?

Thanks

5 Replies
erichshiino
Partner - Master
Partner - Master

Hi,

This previous post has some discussion on the subject. Basically you have to write a macro, since QlikView is to designed for writing back.

http://community.qlik.com/forums/t/20047.aspx?PageIndex=1

To get more posts, search for 'Wirte back', 'write to database' , 'write to sql', 'write to excel' etc

Not applicable
Author

Bro,

Please find out the sample atatched to do the same .

Here you can do this by using macro.

YOU HAVE TO ALTER A BIT (PATH CHANGE) IN MACRO.

Dushyant

Not applicable
Author

Please have alook at this sample qvw also.

Not applicable
Author

Hi,

with ADODB connection is it possible to use the Windows authentication?

Thanks

Not applicable
Author

hi dushyant:

Can you write back the QV table data into Sql server? For example I have created a what if analysis report in qlikview. And after I selected some conditions I want save this version. Then write back to DB, then can compare the actual data & version data.

Thanks/peach