topic Re: adding time of data load to qlikview document in QlikView https://community.qlik.com/t5/QlikView/adding-time-of-data-load-to-qlikview-document/m-p/391398#M145973 <HTML><HEAD></HEAD><BODY><P>Thanx! perfect!</P><P></P><P>chris</P></BODY></HTML> Thu, 01 Nov 2012 08:34:01 GMT chriscools 2012-11-01T08:34:01Z adding time of data load to qlikview document https://community.qlik.com/t5/QlikView/adding-time-of-data-load-to-qlikview-document/m-p/391396#M145971 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>i would like to ad a timestamp in my qlikview document, to show when the data in qlikview server was last reloaded.</P><P>This way it is 100% clear to users data was taken out of our ERP system at what time.</P><P></P><P>what is the best way to do this?</P><P>is it with an expression in the document itself?</P><P>or does this info have to be in the data-load?</P><P></P><P>thanx!</P><P>chris</P></BODY></HTML> Thu, 01 Nov 2012 08:02:15 GMT https://community.qlik.com/t5/QlikView/adding-time-of-data-load-to-qlikview-document/m-p/391396#M145971 chriscools 2012-11-01T08:02:15Z Re: adding time of data load to qlikview document https://community.qlik.com/t5/QlikView/adding-time-of-data-load-to-qlikview-document/m-p/391397#M145972 <HTML><HEAD></HEAD><BODY><P>You can use the reloadtime() function to get the last datetime the load script was run. If you want a more specific time for a specific load action you can use something like Let vTimeERP = now(1) directly after the ERP load to put the time when the ERP load finished in a variable vTimeERP.</P></BODY></HTML> Thu, 01 Nov 2012 08:13:55 GMT https://community.qlik.com/t5/QlikView/adding-time-of-data-load-to-qlikview-document/m-p/391397#M145972 Gysbert_Wassenaar 2012-11-01T08:13:55Z Re: adding time of data load to qlikview document https://community.qlik.com/t5/QlikView/adding-time-of-data-load-to-qlikview-document/m-p/391398#M145973 <HTML><HEAD></HEAD><BODY><P>Thanx! perfect!</P><P></P><P>chris</P></BODY></HTML> Thu, 01 Nov 2012 08:34:01 GMT https://community.qlik.com/t5/QlikView/adding-time-of-data-load-to-qlikview-document/m-p/391398#M145973 chriscools 2012-11-01T08:34:01Z Re: adding time of data load to qlikview document https://community.qlik.com/t5/QlikView/adding-time-of-data-load-to-qlikview-document/m-p/391399#M145974 <HTML><HEAD></HEAD><BODY><P> Hello,</P><P></P><P>it seems that with the above mentioned solution i get the script is reloaded again, but what i'm looking for is how to get the time the data was taken out of ERP and loaded into the qlikview server.</P><P></P><P>now if someone hits the "reload script" button, the time also gets updated, but it can still be that the loaded data is almost a day old.</P><P>And it's the hour the data was collected that i wan't to show... any ideas?</P><P></P><P>grtz,</P><P>chris</P></BODY></HTML> Thu, 08 Nov 2012 13:24:49 GMT https://community.qlik.com/t5/QlikView/adding-time-of-data-load-to-qlikview-document/m-p/391399#M145974 chriscools 2012-11-08T13:24:49Z Re: adding time of data load to qlikview document https://community.qlik.com/t5/QlikView/adding-time-of-data-load-to-qlikview-document/m-p/391400#M145975 <HTML><HEAD></HEAD><BODY><P>I dont think it is possible if you have just one qvw file where you load your source data.</P><P></P><P>If you use an QVD Generator for creating QVD files, you are able to add a date time field to your tables. If you load the QVD Files, as source instead of directly from your source system, into your qvw file you have the creation datetime value in your data.</P><P></P><P>Hope this helps</P></BODY></HTML> Thu, 08 Nov 2012 13:45:19 GMT https://community.qlik.com/t5/QlikView/adding-time-of-data-load-to-qlikview-document/m-p/391400#M145975 2012-11-08T13:45:19Z Re: adding time of data load to qlikview document https://community.qlik.com/t5/QlikView/adding-time-of-data-load-to-qlikview-document/m-p/391401#M145976 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>our ERP supplier created the load with qvd files for us, so i guess i'll probably have to ask them to do it for me...</P><P></P><P>thanx!</P><P></P><P>chris </P></BODY></HTML> Thu, 08 Nov 2012 15:22:57 GMT https://community.qlik.com/t5/QlikView/adding-time-of-data-load-to-qlikview-document/m-p/391401#M145976 chriscools 2012-11-08T15:22:57Z