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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export to Excel with embedded Macro

I would like to know if it is possible in the server version to export a view to an Excel document that automatically proposes macros for data processing that are relevant for the data at hands?

Or alternatively to propose an Export tool, that pops up when user chooses to export, and that leave to the user the choice to select some clean-up macros for exported document?

Or to propose to user to apply some script on some view/data copied at the client side?

Regards

4 Replies
luciancotea
Specialist
Specialist

One word: NPrinting

vikasmahajan

Really Macros are the not the best practice while in qlikview but I am attaching same excel export from macros.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
fkeuroglian
Partner - Master
Partner - Master

Hi, you can do it using macros, but will be a bit diffiicult and requiered some manteinance

in other hand you could see some about nprinting

Informes de QlikView bien hechos | NPrinting

Gral Video

https://www.youtube.com/watch?v=ELruekTSsIg

Send Mail with attachment

QlikView data reports sent as pdf or xls email attachments - YouTube

Good luck

Fernando

Not applicable
Author

Thanks. I would like not to use third party. Would you have more details about how to do this with macros?

Thanks in advance