topic Send to Excel Button in QlikView

Send to Excel Button

gerhardl — Fri, 29 Apr 2011 14:38:49 GMT

Hi,'

I have a table box with a number of fields - I have no real use for it in QV except that once certain selections have been made I export this table to excel.

Is there any way to have a button, which will export the fields in the table box to excel, instead of showing the actual table box?

I've tried to add a button with export action, then I select the fields, but it doesn't seem to give me the option of "send to excel"

Thanks,

Send to Excel Button

Denis_Brajkovic — Fri, 29 Apr 2011 15:19:28 GMT

Please check the attached qvw that performs what your looking for. Theremaining thing is to hide the table box

Send to Excel Button

gerhardl — Fri, 29 Apr 2011 15:21:53 GMT

Hi DBC,

Unfortunately I'm using Qlikview PE (for now) so I cannot open your document. If it's not oo much trouble could you please post what I should do?

Much appreciated,

Send to Excel Button

Denis_Brajkovic — Fri, 29 Apr 2011 15:28:42 GMT

Add a button -> Actions -> Export -> Setup

Then choose

the fields you'd like to export

Radio button Export to FIle Type in directory C:\test.xls

Choose Include lables and radio button records

Send to Excel Button

gerhardl — Fri, 29 Apr 2011 15:36:16 GMT

Thanks -

That does work - but I do not get the option of .xls under file type. I can force it (type the file name as test.xls and then when I open the file I ignore the excel message saying it is ina different format than the extension) but I have account numbers and they then all display as 1.02E+19.

Guess "export to excel" is my best bet...

Re: Send to Excel Button

Padmini — Wed, 22 May 2019 11:00:43 GMT

Hi Dbc,

Please can you help me on how to configure the path when using from accesspoint. I want the excel to be pasted in the downloads folder of each individual.Thanks

Regards

Padmini