Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

wonkymeister
Contributor

Time/Date Stamp Export to Excel

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!

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Time/Date Stamp Export to Excel

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.

3 Replies
Not applicable

Re: Time/Date Stamp Export to Excel

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.

wonkymeister
Contributor

Re: Time/Date Stamp Export to Excel

cheers!

Not applicable

Re: Time/Date Stamp Export to Excel

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.

Community Browser