Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Macro to Export object in Separate Sheet


Let's say i have sheet 1(id = sh1), sheet 2(id = sh2) and straight table(id = Ch1) in sheet 2. I'm currently in Sheet 1 and would like to create a button that runs a macro to do the following:

- export the data in straight table that is in sheet 2 to csv. 

- the macro/button should be on sheet 1.

Can someone help with the macro to do this? Let me know if there are any questions.



1 Reply
Digital Support
Digital Support

There are multiple prior posts on macros related to exporting to CSV, but you can simply use the Button object Export Action to export to a CSV file as well, no macro needed, which will be much more efficient than a macro which will force a single-thread condition on the calculations etc.  

Here is one of the prior Community Posts I found doing a quick search:



To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.