Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

macro export to excel

Hi,everyone

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

   please see my attchment.

   Thanks a lot !

5 Replies
marcus_sommer

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

- Marcus

Not applicable
Author

thanks,Marcus,then

        Is there any solution for just this issue?

marcus_sommer

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

Not applicable
Author

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

marcus_sommer

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