Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. 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