topic Re: macro export to excel in QlikView

macro export to excel

Thu, 22 Dec 2016 07:59:12 GMT

Hi,everyone

I meet a problem, when I turn on webview, the macro don't work .

please see my attchment.

Thanks a lot !

Re: macro export to excel

marcus_sommer — Thu, 22 Dec 2016 08:17:21 GMT

Most of the macros don't work within the webview or AJAX clients because it's just html + javascript.

- Marcus

Re: macro export to excel

Fri, 23 Dec 2016 11:05:18 GMT

thanks,Marcus,then

Is there any solution for just this issue?

Re: macro export to excel

marcus_sommer — Fri, 23 Dec 2016 11:54:12 GMT

You need to keep it within the desktop-mode or using the IE plugin (by using server + access point) - otherwise you could only use the manually options of sending to excel or copy & paste.

An alternative might be also to store your needed data by the script-run into a csv-file which you could then open with excel.

- Marcus

Re: macro export to excel

Fri, 23 Dec 2016 12:10:28 GMT

Does it mean: it will be work if putting this doc on a qlikview server? (For there has IE plugin)

Could you give a sample?

Marcus,

thanks a lot

Re: macro export to excel

marcus_sommer — Fri, 23 Dec 2016 13:27:12 GMT

Yes by using the application over a server per IE plugin you could use macros.

Here an example how to store data into a csv:

YourExportTable:

load Field1, Field2, ... From YourPreparedDataSource;

store YourExportTable into YourExportTable.csv (txt);

- Marcus