topic Re: creating qvd with a button in QlikView

creating qvd with a button

Fri, 31 Jan 2014 12:44:53 GMT

hi all,

can i create a qvd directly exporting data from current selection box with the help of a button. can anyone help me with the steps please/.

thanks..

Re: creating qvd with a button

Fri, 31 Jan 2014 12:54:18 GMT

Could you plz explain your requirement clearly?

You can create QVD by giving the STORE TableName into [your path\Name.qvd](qvd); command.

Or instead you can use Variable for your path.

Re: creating qvd with a button

Fri, 31 Jan 2014 13:06:49 GMT

I think this thread is for you :http://community.qlik.com/thread/7715

Fabrice

Re: creating qvd with a button

Fri, 31 Jan 2014 13:33:56 GMT

Hi Fabrice,

I added below script in the edit module with action run macro for the button:

sub StoreCH1TableToQVD

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportEx "D:\bqv.qvd", 4

end sub

after i click the button created , i m redirected to edit module again

which step am i missing here?

:Aditi

Re: creating qvd with a button

Fri, 31 Jan 2014 13:36:49 GMT

hi,

my question is whatever selections i have made in qvw file, that is shown in current selection window, this particular selection , i want to export as qvd with the help of a button. i know how to create a qvd with store command. but want to try with a button

Re: creating qvd with a button

Fri, 31 Jan 2014 13:36:59 GMT

HI aditi, Please make sure that you gave correct chart object ID.

Re: creating qvd with a button

Fri, 31 Jan 2014 13:40:10 GMT

mu current selection chart object ID is: CS01. even after trying with this in the code, edit module comes up.

Re: creating qvd with a button

Peter_Cammaert — Fri, 31 Jan 2014 13:40:23 GMT

Are you running your Script with "System Access" security?

Peter

Re: creating qvd with a button

Fri, 31 Jan 2014 13:43:06 GMT

well yes, but other simlar actions are working properly.

Re: creating qvd with a button

Peter_Cammaert — Fri, 31 Jan 2014 13:49:42 GMT

Try writing to the document directory, e.g.

obj.ExportEx ".\bqv.qvd", 4

Peter

Re: creating qvd with a button

Fri, 31 Jan 2014 13:53:50 GMT

its still the same.

Re: creating qvd with a button

ashwanin — Fri, 31 Jan 2014 13:55:43 GMT

Hi Aditi,

I read the thread in which same problem was mentioned,

and i got to know that you have missed the below

ActiveDocument.PartialReload

can you past it within macro and run that?

Re: creating qvd with a button

Peter_Cammaert — Fri, 31 Jan 2014 14:09:38 GMT

It seems you cannot export a Current Selections box to QVD (your "CS01"). Seems Logical...

Peter

Re: creating qvd with a button

Peter_Cammaert — Fri, 31 Jan 2014 14:12:32 GMT

Two cases where the Edit Module window pops up when executing an export macro:

Only some object types can be exported to QVD. Consult APIGuide.qvw to find out which object types
The object you're trying to export must exist (but it can be completely empty)

Peter

Re: creating qvd with a button

Fri, 31 Jan 2014 14:18:11 GMT

Aditi, you can't export current selection box object to qvd.

Re: creating qvd with a button

Mon, 03 Feb 2014 05:43:00 GMT

So, is there any solution for it, for whatever selection i have made, same data can be exported from qvd button if not from current selection box.