topic From Pivot Chart, Export to Oracle Database in QlikView

From Pivot Chart, Export to Oracle Database

Thu, 29 Apr 2010 15:07:52 GMT

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

From Pivot Chart, Export to Oracle Database

Tue, 25 Jan 2011 12:04:57 GMT

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.

From Pivot Chart, Export to Oracle Database

deepakk — Tue, 25 Jan 2011 13:24:30 GMT

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")

From Pivot Chart, Export to Oracle Database

gauravkhare — Tue, 25 Jan 2011 13:27:44 GMT

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

From Pivot Chart, Export to Oracle Database

suniljain — Tue, 25 Jan 2011 13:32:49 GMT

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.

From Pivot Chart, Export to Oracle Database

Tue, 25 Jan 2011 13:40:49 GMT


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.