topic Time/Date Stamp Export to Excel in QlikView

Time/Date Stamp Export to Excel

wonkymeister — Fri, 15 Nov 2013 08:50:21 GMT

Morning,

is it possible to add a title/timestamp for charts/tables when exporting to excel?

i know the exported file has the time stamp in the file name (as well as the object id)

but is it possible to add anything to the excel sheet itself in order that its easy for the user to understand what they're looking at?

cheers,

Happy Friday!

Re: Time/Date Stamp Export to Excel

Fri, 15 Nov 2013 13:39:17 GMT

You can achieve some different ways:

1. Include the Current Seelctions while export by setting: User Preferences --> Export --> Selection Stamps in Exports --- Check the On BIFF Exports

Include the field TIMESTAMP on the current selections.

2. Add the new field Today() as Date of export and this value get on each row.

Re: Time/Date Stamp Export to Excel

wonkymeister — Fri, 15 Nov 2013 15:45:41 GMT

cheers!

Re: Time/Date Stamp Export to Excel

Wed, 04 Mar 2015 13:09:12 GMT

Can you tell me how to include the field TIMESTAMP inot the current selection box?

Is this field in QV by default or is there a need to create this first?

I have enabled Selection Stamps in Exports = "on BIFF Exports" but no timestamp is exported.

Help is greatly appreciated.