topic Re: Exporting to Excel in QlikView

Exporting to Excel

Fri, 27 Jul 2012 18:39:59 GMT

Hi all, I still feel new to Qlikview even though I have been working with it for a couple months. Does anyone know if I can use the functionality behind the 'XL' (Export to Excel located at the top left of a chart) in a command button? In a nutshell, I want to create a command button that 'Select in Field,' and then drops the beautiful data format obtain from the 'XL.' The idea behind my request is for non-technical, high-level users of data to click on the sheet, and download a report for their division. The export to excel macros I found in the community do not run or run correctly due to restrictions on the computer, but the 'XL' works wonderfully. Thank you in advance. Don the intern

Re: Exporting to Excel

Fri, 27 Jul 2012 21:13:54 GMT

Take a look at the attached example and see if it is what you had in mind. Under Tool > Edit Module, ensure that you have 'System Acces' selected under 'Requested Module Security' and 'Allow System Access' selected under 'Current Local Security' before clicking the 'Export to Excel' button. This is probably why your macros weren't running before.

Re: Exporting to Excel

Mon, 30 Jul 2012 11:40:45 GMT

Excellent, thank you so much!

Re: Exporting to Excel

qlikviewforum — Fri, 05 Oct 2012 18:04:12 GMT

I want to export the same into txt after getting exported to excel. Could you please help me out for the same please?

Re: Exporting to Excel

Fri, 05 Oct 2012 21:57:34 GMT

Try something like this. I am not sure if you data will be compatible as a text file with this or not, but give it a shot. We can always tweak it if it doesn't work.

Re: Exporting to Excel

qlikviewforum — Sat, 06 Oct 2012 04:06:52 GMT

Thanks for your help! Can the text files be saved automatically through macro without the need of users. As we want this to be automated without the need of users.

Re: Exporting to Excel

Mon, 08 Oct 2012 13:06:50 GMT

You can set the macro to run as a trigger in Document Properties. For example, you can set the action to run the macro on every reload.

Re: Exporting to Excel

pnn44794 — Wed, 18 Apr 2018 23:38:56 GMT

Hello Rebecca:

Nice work. Is there a way to make this run on OnPostReload trigger and to go to a specified location, i.e. to server in a particular folder? If yes, how would the code need to be tweaked? I'm also guessing the filename would need to be unique each time like with a data appended. Thanks in advance.