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

From Pivot Chart, Export to Oracle Database

Hi,

I am looking to export the pivot table using macro to Oracle Database. Let me know how this can be done.

Thanks in advance.

Bala

5 Replies
Not applicable
Author

Hi Bala

I am also looking for something similar to this only. I want to export the out of a qlikview data to the database.

Did you got any solution for this. If you have any solution please share with me please.

deepakk
Partner - Specialist III
Partner - Specialist III

hi,

you can search for VB codes and use it in macro. Something similar to below. I had done this in a small way. But currently doesn't have the exact codes. but I think you can start of your search from below codes and let me know if you guys need any help on the same.

connection = CreateObject("ADODB.Connection")Set rows = CreateObject("ADODB.Recordset")


gauravkhare
Creator II
Creator II

hi kmbmk,

not to sure about your query but i feel that this can be achieved by going to expreesions and then to representation and then we can assign a link to dynamically upload/export the data from qlikview to some other db.

the above is one possible way to achieve your requirment. Kindly let me know about the solution. I will be following your query.

Regards

Gaurav

suniljain
Master
Master

This task is possible only through internediate place. you can export pivot table in CSV or Excel and then import that excel or CSV in database whether its sequel or oracle.

I think it is not posisble through the way suggested by others in this post.

Not applicable
Author


Gaurav wrote:
not to sure about your query but i feel that this can be achieved by going to expreesions and then to representation and then we can assign a link to dynamically upload/export the data from qlikview to some other db.
the above is one possible way to achieve your requirment. Kindly let me know about the solution. I will be following your query. <div></div>


Could you please attach any sample application which does the same.