topic export to Excel in QlikView

export to Excel

Anonymous — Mon, 29 Jun 2015 14:47:39 GMT

Hi,

Is it possible to assign a function 'Export to Excel' to a text object or a button separate from a table?

Thank you in advacne,

Larisa

Anonymous — Mon, 29 Jun 2015 17:47:03 GMT

Hi,

yes, I think the best way is using a macro from the button.

You can find macro for Excel export in the community, for example here:

I hope this can help you.

Regards.

Anonymous — Mon, 29 Jun 2015 18:10:30 GMT

Or simply use obj.ExportEx in the macro.

See attached file.

Regards.

Anonymous — Tue, 30 Jun 2015 07:11:39 GMT

Hi,

work this fine or not?

If this is ok close the thread, thank you.

Regards.

Anonymous — Tue, 30 Jun 2015 07:57:41 GMT

Hi,

I tried the file TestExport.qvw. In my desktop QlikView it doesn't work.

By the way, is the macro you suggest of the same nature as a standard Excel macro or is it a special QlikView macro?

Many of our users forbid to run macros in Excel settings. Does your suggestion take into account Excel settings of a particular user?

Anonymous — Tue, 30 Jun 2015 08:22:27 GMT

This is a macro of Qlikview, you can see this if you go to the button propreties and see actions.

I know that is better to dont use macro but I don know if you can do what you want to do from a button without a macro.