Exporting to Excel

[#1]

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

[#2 · Accepted solution]

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.

[#3]

Excellent, thank you so much!

[qlikviewforum]

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

[#5]

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.

[qlikviewforum]

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.

[#7]

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.

[pnn44794]

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.