topic Re: Current Timestamp as historical Timestamp? in QlikView

Current Timestamp as historical Timestamp?

Tue, 30 Apr 2013 15:48:20 GMT

I am working on capturing a count of rows in a table on a daily basis but want to store that moment in time count in a QVD with the timestamp of when that count was done. But I've been unsuccessful with storing the timestamp (I have been using ReLoadTime) as an historical/QVD table value.

Does anyone have any guidance?

Thank you!

Re: Current Timestamp as historical Timestamp?

kaushiknsolanki — Tue, 30 Apr 2013 16:10:43 GMT

Hi,

You can try something like this to include the timestamp when storing the data in QVD.

ABC:

Load Field1,Field2, now() as TimeStamp from xyz;

Store ABC into ABC.qvd;

Regards,

Kaushik Solanki