Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
QV reads from a SQL Server database but is it possible to write on a db? How? Is there a sample?
Thanks
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
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
Please have alook at this sample qvw also.
Hi,
with ADODB connection is it possible to use the Windows authentication?
Thanks
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