topic Re: Createing a QVD from a chart in QlikView

Createing a QVD from a chart

Anonymous — Wed, 19 Jun 2013 12:38:37 GMT

I have a pivot chart that I want to store data from.

I want to store them into a QVD every night.

I found a tread that stated:

Create a macro with

Set obj=ActiveDocument.GetSheetObject(CH18)

obj.ExportEX "C:\test.qvd", 4

So I tried by ctrl+m and inserted the above code.

But get the error "Object required: 'obj'"

I have not tried macro before, so I`m way out of my comfort zone.

Re: Createing a QVD from a chart

Wed, 19 Jun 2013 13:38:22 GMT

Hi Dan,

You just need to enclose the object ID within double quotes like this:

Set obj=ActiveDocument.GetSheetObject("CH18")

and the qvd will be created.

Re: Createing a QVD from a chart

Anonymous — Wed, 19 Jun 2013 13:45:34 GMT

HI JP

Will the macro start all by it self if a create a task and schedule it to say 00:10?

Re: Createing a QVD from a chart

Wed, 19 Jun 2013 13:55:44 GMT

Well you can use the OnPostReload document trigger to run the created macro.

Is that suitable in your case ?

Re: Createing a QVD from a chart

Anonymous — Thu, 20 Jun 2013 09:43:45 GMT

Thanks for your input. Works like a charm.

Re: Createing a QVD from a chart

dmohanty — Thu, 09 Jul 2015 20:46:12 GMT

Hi Dan,

We have a similar requirement. It didn't work like a charm for us

Are you running the QVW with OnPostReload, manually or through Publisher/QMC?

Seems Publisher is not supporting the OnPostReload. I am able to store the Chart data into QVD, if I run the QVW manually with OnPostReload trigger, but QVD is not created when QVW is ran on QMC.

Please suggest.