topic Re: Export to Excel by Button in QlikView

Export to Excel by Button

Thu, 10 Sep 2015 14:21:09 GMT

jagan‌ vinay_bangari‌ ecolomer‌

Hi Experts,

I'm not familiar with macros at all…! Unfortunately, not even the basics..

I need a button that will export a table to excel. Please find the attached qvw file below.

Thank you in advance.

Re: Export to Excel by Button

m_woolf — Thu, 10 Sep 2015 14:32:19 GMT

Please search the forum. You will find many examples.

Be advised that this macro will not work with Ajax. Only with IE and the plug-in.

Re: Export to Excel by Button

hjweber — Thu, 10 Sep 2015 14:34:51 GMT

Hi Raji,

see the example.

Re: Export to Excel by Button

Thu, 10 Sep 2015 14:40:21 GMT

Please check the attachment

The file name is written in the macro.
It is generated in the same folder where the qvw.
If you need you can add a new action to open automatically with the application you want

Re: Export to Excel by Button

Anonymous — Thu, 10 Sep 2015 14:49:55 GMT

Urgent need help on sending Qlikview reports in any exported format to users Email.

check this discussion which i posted earlier

Re: Export to Excel by Button

Thu, 10 Sep 2015 14:50:36 GMT

Hi Gennaro,

thanks for ur help. its working.. One more question..

Can i add the Current selection Box to the same Excel sheet which you have created. So that it shows the filters on top.

Thanks in advance.

Re: Export to Excel by Button

Thu, 10 Sep 2015 15:16:46 GMT

Yes check the attachment

If it is correct, do not forget to mark the discussion as answer

Regars

Gennaro

Re: Export to Excel by Button

Mon, 14 Sep 2015 13:53:55 GMT

Hi Gennaro,

I have tried to use the Macro for other objects also by changing the OBJECT ID in the Macro. But some how its not working. When i have tried to use i don't know why the values are changing automatically. Please help and find the attached QVW file to the question.

Re: Export to Excel by Button

Mon, 14 Sep 2015 14:41:11 GMT

Hi Raji,

look the attached file with the changes to export the various tables that you've created.
I modified the macro so that the parameter object to export is specified by a variable.

Re: Export to Excel by Button

Mon, 14 Sep 2015 14:46:32 GMT

Thank You its working...

Re: Export to Excel by Button

Mon, 14 Sep 2015 15:48:10 GMT

Hi Gennaro,

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

Thanks,

Raji

Re: Export to Excel by Button

Tue, 15 Sep 2015 10:34:40 GMT

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.

Re: Export to Excel by Button

gautik92 — Tue, 15 Sep 2015 10:38:17 GMT

Have a look at this

Re: Export to Excel by Button

Tue, 15 Sep 2015 16:51:07 GMT

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

Re: Export to Excel by Button

Tue, 15 Sep 2015 17:56:36 GMT

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.

Re: Export to Excel by Button

Wed, 16 Sep 2015 12:19:49 GMT

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).

Re: Export to Excel by Button

Wed, 16 Sep 2015 13:28:51 GMT

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

Re: Export to Excel by Button

Thu, 17 Sep 2015 08:46:47 GMT

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

Re: Export to Excel by Button

Thu, 17 Sep 2015 14:59:07 GMT

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

Re: Export to Excel by Button

Thu, 17 Sep 2015 15:51:04 GMT

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