export

Report Inappropriate Content · ‎2013-12-04

when you export chart/table out of qlikview and into excel - how can you change the name of the excel doc created eg rather than the generic chart number & date?

MayilVahanan · ‎2013-12-04

HI

Try with macro

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

lotfiblo · ‎2013-12-04

Hi,

Add this to your macro

objExcelWorkbook.SaveAs "YourPath\NameOfDocument.xls"
objExcelWorkbook.close

Lotfi

Use Qalyptus for your Qlik Sense on-premise and Qlik Sense SaaS Reporting
Connect with me on Linkedin

Anonymous · ‎2014-03-28

Go to the table/chart properties and in the general tab, give the name of the excel you need in the object ID.

This will export the excel with the name given instead of the default chart id.

ThornOfCrowns · ‎2014-03-28

As said in this thread: http://community.qlik.com/thread/96968

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.

Related Topics