Last Update to Database

[Ari_B]

Hi everyone! 

I am trying to make a title for a KPI that displays the date and time the database that is contributing the data was last updated.  

I do not want when the data was last loaded onto Qlik Sense but when the database itself was last updated.  

I know that =reloadtime() gives a timestamp for when the data was last loaded into Qlik but I would like to have the update time for the database itself displayed.  

Is there any way to do this as a function in the Title? 

Thank you! 

[rwunderlich · Accepted solution]

I typically address this requirement by displaying the latest transaction time for the type of data I am displaying. Something like:

='Orders as of ' & TimeStamp(Max({1} OrderDateTime))

-Rob

[Ari_B]

Hey,

This works wonderfully! 

Thank you very much!