topic Timestamp on export to Excel in QlikView

Timestamp on export to Excel

Thu, 05 Mar 2015 07:39:53 GMT

Good morning

I need to know how to include a timestamp for all exports to excel?

I tried to follow what has been written in another discussion, but got stuck.

Time/Date Stamp Export to Excel

My question:

Is this field TIMESTAMP 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.
Your help is greatly appreciated.

Re: Timestamp on export to Excel

Peter_Cammaert — Thu, 05 Mar 2015 08:08:52 GMT

If you just try an export to Excel/send Values to Excel with this option enabled you will see what is meant: a selection overview or a Calendar date will be included at the bottom of the exported data. Scroll down to the end of any large table to find it.

Edit: I take back my words. Apparently a TimeStamp value is included only if you create such a field and select it (or enable "Always one selected"). It can be hidden if you like. There is no standard date / time value included in the selection status. If nothing was selected at the time of export, the text "No selections" is displayed at the end of the data.

Re: Timestamp on export to Excel

Wed, 12 Aug 2015 05:45:24 GMT

Hi Peter,

you are right. QV only adds a timestamp if a certain date is selected and hence included in the "current selection" object.

The file itself that gets created however contains a timestamp.

Thanks

Marco