Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Partner
Partner

ORACLE 11g Connection by Macro

HI TO ALL....

There are two bookmarks called Set1 and Set2 and i would like to STORE the SetAnalysis result IN AN ORACLE DB 11g.

For example:

- If you wanna visualize the CONSUMER_ID have bought FIAT GRANDE PUNTO press the button 'Set 1'.

Will be {16,17,18,19,20,21,22,23,24,25,26,32,33,34,35}

- If you wanna visualize the CONSUMER_ID have bought FIAT PANDA MY 03 press the button 'Set 2'.

Will be {1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}

So, in the table called RESULT there are the consumer_id result of the intersection of two Sets {16,17,18,19,20}

Can You build a MACRO in VBA for CONNECT AND STORE the INFORMATION in an ORACLE DB 11g version?

I would like to store the table result called 'RESULT'. So, I would like to invoke the macro called 'store_in_ORACLE'

from the button on the dashboard called 'STORE RESULT IN ORACLE DB'.

Thanks a lot, Paolo.

PS: there is an attachment file.

1 Reply
Not applicable

Re: ORACLE 11g Connection by Macro

Hello!

Did you maybe find a solution?

Br,

M