Macro to pull data from Qlikview to Excel based on a parameters defined

Mon, 11 Jul 2011 12:39:58 GMT

Hi all,

i have a problem, thanks in advance for any suggests: selecting parameters for e.g. from one date to other date and for a particular region and then export it to excel which usually takes lot of time.

I need to use something like a macro to solve my problem, but when i try to write it, it doesn't work. (Qlikview doesn't waiting for new selectiong, it export a bad copy of current table before the new selection is apply ).

I see this thread :

http://community.qlik.com/message/89430?tstart=0

but unfortunatly the resource ( http://community.qlik.com/media/p/90766.aspx ) was stored in shared part of previous QlikCommunity system, and it seems was not trasfereed into new one. Also Nick haven't anymore this program.

Anyone have a similar macro ?

Thanks a lot!

Macro to pull data from Qlikview to Excel based on a parameters defined

Mon, 11 Jul 2011 15:02:57 GMT

Try adding a command to run the WaitForIdle method before the export to allow QlikView to finish redrawing the chart. Like this: ActiveDocument.GetApplication.WaitForIdle

Re: Macro to pull data from Qlikview to Excel based on a parameters defined

Mon, 11 Jul 2011 16:10:56 GMT

Thank Tim,

i try your solution. I hope it works

topic Macro to pull data from Qlikview to Excel based on a parameters defined in QlikView

Macro to pull data from Qlikview to Excel based on a parameters defined

Macro to pull data from Qlikview to Excel based on a parameters defined

Re: Macro to pull data from Qlikview to Excel based on a parameters defined