topic Re: Define file name when sending to Excel in QlikView

Define file name when sending to Excel

Thu, 24 Oct 2013 09:56:48 GMT

Hi,

Is there any way to define the file name when sending a chart to Excel? Currently it is just some random number like 146e80312fae44b7a9dc0efbc34e213f.xls which is not too popular among our customers.

Thanks in advance

Re: Define file name when sending to Excel

Thu, 24 Oct 2013 10:07:49 GMT

Yes you can achieve this functionality but not by using default Send to Excel button. You can apply a Macro on the chart and during applying macro you can provide the name of the file so that when macro is executed, the excel file will save on your provided path and with your provided name of the file.

Re: Define file name when sending to Excel

Thu, 24 Oct 2013 10:08:40 GMT

and If you need help creating a macro let me know and i'll help you out.

Re: Define file name when sending to Excel

Thu, 24 Oct 2013 10:12:44 GMT

Thanks, that's very kind of you.

Can this functionality replace the current one, so that when I click on the "Send to Excel" button in any chart this would be invoked? Or do I need to add a special button on every chart?

Re: Define file name when sending to Excel

Thu, 24 Oct 2013 10:16:34 GMT

You need to create button for this purpose.

If you have few tables from which you need to export data into excel then applying macro will be sensible choice but if you want this functionality on all of your tables then this is not a wise way to go.

Re: Define file name when sending to Excel

Thu, 24 Oct 2013 10:30:21 GMT

Yeah that's the problem. Way too many charts to export from. Any other ideas?

Re: Define file name when sending to Excel

Thu, 24 Oct 2013 10:40:09 GMT

I dont have any other idea. maybe there's someother way around i dont know of.

Re: Define file name when sending to Excel

jagan — Thu, 24 Oct 2013 10:47:37 GMT

Hi,

There is no such functionality to define the file name when you Export to Excel using default, you need to write macro and achieve this. There is no other way, no configuration or setting for this.

But what we can do is, create a list of all objects (Object IDs) and display it in list box, ask user to select the ID and use single macro and button to export this. The macro should be dynamic to export the selected Object ID.

Regards,

Jagan.

Re: Define file name when sending to Excel

Anonymous — Fri, 28 Mar 2014 15:06:25 GMT

Go to the table/chart and in the general tab, use the name of the excel file you wish to replace the object ID.

This should now export the excel with the namegiven_date_time.xlsx format.

Re: Define file name when sending to Excel

ThornOfCrowns — Fri, 28 Mar 2014 15:14:23 GMT

The filename is generated as Objectname_YYYYDDMM_hhmmss, so it's not entirely random. If you name your objects in a meaningful way, rather than using the default "CH367" etc., you may not have such a problem in future file recognition.

Re: Define file name when sending to Excel

Wed, 09 Apr 2014 07:18:20 GMT

Thank you vamshi tatipelli and James Summerson - didn't realize there was a connection between the object id and the Excel file name.

Re: Define file name when sending to Excel

Anonymous — Wed, 04 Feb 2015 15:24:42 GMT

hi,

my file is generated as "dea331a1e87146dab76f577a6917201a.xls"

not as you mentioned in your comment,

do you have a guess why?

thanks,

Nir