topic Re: How to modify the standard excel export function in QlikView

How to modify the standard excel export function

doncorleone — Wed, 12 Jun 2013 12:16:47 GMT

I'd like to add certain information to the standard excel export function (the one you can activate the icon for in the chart property tab "caption").

For example we need the chart title and the current date in our excel exports. I already managed to export the current selections to Excel.

I don't want to create a specific marco, I want the standard excel export function (via chart icon "XL") to provide this information in the excel export for every chart we use.

Can anyone help ?

Thanks a lot !

Re: How to modify the standard excel export function

Gysbert_Wassenaar — Wed, 12 Jun 2013 14:10:31 GMT

Only Qliktech can do what you want. It would require rewriting the code for that part of the UI.

Re: How to modify the standard excel export function

doncorleone — Wed, 12 Jun 2013 15:51:30 GMT

Thanks for your fast answer. Ok, I understand. Is there a macro script I could use for my purposes ? Perhaps one I could modify a little. I am not a very advanced scripter and I don't know the syntax very well. The macro should replace the standard excel export function (for multiple charts and with the selection criteria included) plus it should export the chart title and certain criteria from my project, which i could add to the script.

Re: How to modify the standard excel export function

Wed, 12 Jun 2013 15:57:46 GMT

Check this out: http://community.qlik.com/message/208293

Re: How to modify the standard excel export function

doncorleone — Thu, 13 Jun 2013 08:05:02 GMT

Ok, thanks a lot for your help !

Re: How to modify the standard excel export function

Gysbert_Wassenaar — Thu, 13 Jun 2013 11:06:07 GMT

See QlikTip #32: Exporting multiple QV objects to a single Excel document