Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
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
erich_shiino
Partner
Partner

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

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

Please have alook at this sample qvw also.

Not applicable

Hi,

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

Thanks

Not applicable

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