Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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