Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

dan-ketil
Contributor II

Createing a QVD from a chart

Hi

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.

BR

DJ

Tags (3)
1 Solution

Accepted Solutions
Not applicable

Re: Createing a QVD from a chart

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

Is that suitable in your case ?

5 Replies
Not applicable

Re: Createing a QVD from a chart

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.

dan-ketil
Contributor II

Re: Createing a QVD from a chart

HI JP

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

BR

DJ

Not applicable

Re: Createing a QVD from a chart

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

Is that suitable in your case ?

Highlighted
dan-ketil
Contributor II

Re: Createing a QVD from a chart

Thanks for your input. Works like a charm.

BR

DJ

Partner
Partner

Re: Createing a QVD from a chart

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.