Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
Hey,
This works wonderfully!
Thank you very much!