Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-12-04 09:55 AM

export

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?


843 Views
0 Likes
4 Replies
MayilVahanan
MVP
MVP
‎2013-12-04 09:58 AM

HI

Try with macro

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
666 Views
0 Likes
lotfiblo
Creator
Creator
‎2013-12-04 10:22 AM

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
666 Views
0 Likes
Anonymous
Not applicable
‎2014-03-28 11:04 AM
Author

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.

666 Views
ThornOfCrowns
Specialist II
Specialist II
‎2014-03-28 11:22 AM

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.


666 Views
0 Likes