Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Re: Export to Excel by Button

Hi Gennaro,

Sorry, One more question..  Is there anyway that we can Export to PDF by creating the Macro..???

Thanks,

Raji

Not applicable

Re: Export to Excel by Button

Hello Raji,
there is no way to export directly to PDF, but you can use QlikView reports.

That is, it creates one or more reports and then with a macro molds in PDF via the API PDFCreator you have to install on the machine where you use the qvw.

I hope I was clear.

Highlighted
gautik92
Valued Contributor III

Re: Export to Excel by Button

Have a look at this

Not applicable

Re: Export to Excel by Button

g.voto76

Hi Gennaro,

Thanks for the Response. I have couple of questions.

  • Do i have to install API PDFCreator on my Local Machine..??
  • If i move my Application to the Production Machine what will happen..?? Will it work..??
  • The Macro which we created before for Export to Excel will that also work in Prod Machine..??

Thanks for your help..

Raji

Not applicable

Re: Export to Excel by Button

Hi Gennaro,

I have one more issue with this Macro.. I'm trying to display 3 objects at a time in Excel sheets. But some how its not working. Can you please help me on this too..?? Please find the attached qvw file with name "2ObjectsforMacro" (In this File i have taken a container Chart but its not exporting to excel because the container has 2 objects)

Thank you for your patience.

Not applicable

Re: Export to Excel by Button

Hi Raji,

You can not export a container object, but only the objects that are contained in it.
Excuse but today I can mdificarti your qvw to other work commitments.
If you can wait and not solve in the meantime I can control it between 7/8 hours or tomorrow morning (Italian time).

Not applicable

Re: Export to Excel by Button

Sure i'll wait for your response.. Thank You..

Not applicable

Re: Export to Excel by Button

Hi Raji,

sorry for the delay.
Attached you can find your qvw modified to print the two objects in the container.
I added the variables and created a new function in the macro.
Watch the action on one of the buttons and you'll understand.


Regards

Gennaro

Not applicable

Re: Export to Excel by Button

Hi Gennaro,

Thanks for the Response. I have couple of questions.
•Do i have to install API PDFCreator on my Local Machine..??
•If i move my Application to the Production Machine what will happen..?? Will it work..??
•The Macro which we created before for Export to Excel will that also work in Prod Machine..??

Thanks for your help..

Raji

Not applicable

Re: Export to Excel by Button

Hi Raji,

PDFCreator is used to create PDF files (simulates a virtual printer that creates a PDF file that you send in press), if you need to produce PDF you have to install it on your local machine and on the production server.
On the production server to ensure that the MACRO functions you need to enable the execution of the macro in the QMC.

In the System tab select the QlikView Server QVS @ xxxxx and select the Security tab and active flag "Allow macro execution on server"


Regards

Gennaro