topic Re: Adding text while exporting objects using "send to excel" in QlikView

Adding text while exporting objects using "send to excel"

Sat, 24 Jan 2015 13:00:41 GMT

Hi,

Is there a way to add some fixed text (e.g. adding the text "For Internal Use only") to be added to any excel file exported using "Send to Excel object" from a particular QV application. In other words, the QV application has multiple chart objects and I want to ensure that the text is added whenever any of the chart objects are exported to excel.

Re: Adding text while exporting objects using "send to excel"

francoiscave — Sat, 24 Jan 2015 13:32:48 GMT

Hi Balaji,

With the Qlikview "Send to Excel", I think is not possible.

A solution could be to use NPrinting software to do that...

François

Re: Adding text while exporting objects using "send to excel"

marcus_sommer — Sat, 24 Jan 2015 17:31:41 GMT

Within the export-properties is an option to add the current selection-state to the exported object. If you creates an extra dimension-values (maybe as loose table) and select and locked this field it would be returned to each object.

If this don't worked how do you wish you will need a macro-routine which creates/opened an excel-file and copied and pasted multiple objects in them - have a look here on many examples:

http://community.qlik.com/search.jspa?q=macro+export+sheet&type=document

- Marcus