topic Export to Excel in QlikView

Export to Excel

Anonymous — Tue, 22 Jun 2010 16:25:11 GMT

When a user clicks on the XL button, the generated excel file does not contain the caption. How can I include caption? Would it also be possible to include the current selections box in the generated excel file?

Thanks,

Dinesh.

Export to Excel

Wed, 23 Jun 2010 08:17:20 GMT

set the option in:

settings->user prefrences->Export

Export to Excel

Anonymous — Wed, 23 Jun 2010 13:18:00 GMT

That is for exporting the entire Qlickview object. This would mean that I can send this only to Qlickview users. I was referring to the XL option in which only the data, caption & current selection would go to a plan excel file.

Thanks

Export to Excel

Thu, 24 Jun 2010 08:56:45 GMT

have a read of this i think this is the same as your request or very similar.

http://community.qlik.com/forums/t/26857.aspx

Export to Excel

Anonymous — Thu, 24 Jun 2010 10:37:44 GMT

This is certainly helpful. Could that macro be modified to include current selections as well?

Thanks,

Dinesh.

Export to Excel

Thu, 24 Jun 2010 11:56:45 GMT

try here. http://www.qlikblog.at/583/qliktip-1-transferring-current-selections-excelexport-translated/ hope this helps

Export to Excel

Anonymous — Thu, 24 Jun 2010 22:27:48 GMT

Have you tried "User Preferences" --> Export --> Selection Stamps in Exports --> check "On BIFF Exports"?

Export to Excel

Anonymous — Fri, 25 Jun 2010 02:06:11 GMT

Yes I am all set.

Thx