topic Re: Macro to Export object in Separate Sheet in QlikView

Macro to Export object in Separate Sheet

vishalj88 — Sat, 16 Nov 2024 01:27:14 GMT

Hi,

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.

Thanks

Vishal

Re: Macro to Export object in Separate Sheet

Brett_Bleess — Tue, 18 Feb 2020 22:38:53 GMT

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:

https://community.qlik.com/t5/QlikView-Scripting/Export-to-CSV/m-p/680173#M43627

Regards,
Brett