Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
adrianad
New Contributor III

Is it possible to show the reload time from a different Dashboard?

Hi All,

I was wondering if anyone knows of a solution to display the reload time from two or more dashboards.

For example, I have three related dashboards:

1. MainDash

2. ODBC_ExtractorDash

3. SAP_ExtrractorDash

On the MainDash I would like to see the reload times for all three dashboards. For the MainDash itself I use
='Last Update @ '&ReloadTime()

and it works great.

Is it possible to add the ReloadTime() for another dash?

Thank you in advance.

Tags (1)
1 Solution

Accepted Solutions
Partner
Partner

Re: Is it possible to show the reload time from a different Dashboard?

I haven't seen that FileAgeMonitor app seems really interesting. Another option would be to store the reload time as field with an autogenerate statement (In the ODBC and SAP Extractor_Dash) and then load it in the MainDash as an island table:

example for ODBC and SAP extractor_Dash:

LOAD ReloadTime() as ReloadTimeODBC

AUTOGENERATE 1;

store TABLE_NAME into ReloadTime.qvd(qvd);

then in the MainDash you load these qvds with the previously generated tables.

This way, you can show Reload times for any other app you need.

Another option would be like the previous comment says, to pass the reload time through a variable and then use a $(Include 😃 statement so the variable generated in a different document can be present in the actual one.

Greetings

6 Replies
MVP
MVP

Re: Is it possible to show the reload time from a different Dashboard?

You are talking about different QV applications, right?

You just need to provide the reload times to the MainDash application. There might be several solutions to this, you can use Rob's file age monitor as one example to learn how to do this:

http://robwunderlich.com/downloads/FileAgeMonitor.zip

sean_reynolds
New Contributor III

Re: Is it possible to show the reload time from a different Dashboard?

Hi Adrian, Another option: you can load your reload time into variable, load that variable into an inline table in the source document, and then retrieve it from the table in the target document using the peek() function.


-Sean

adrianad
New Contributor III

Re: Is it possible to show the reload time from a different Dashboard?

Indeed, I am talking about different QV applications.

I will definitely have a look at the FileAgeMonitor app as well as solution #2 and let you know if any of them will work for my case.

Thanks for the quick reply! Appreciated.

Partner
Partner

Re: Is it possible to show the reload time from a different Dashboard?

I haven't seen that FileAgeMonitor app seems really interesting. Another option would be to store the reload time as field with an autogenerate statement (In the ODBC and SAP Extractor_Dash) and then load it in the MainDash as an island table:

example for ODBC and SAP extractor_Dash:

LOAD ReloadTime() as ReloadTimeODBC

AUTOGENERATE 1;

store TABLE_NAME into ReloadTime.qvd(qvd);

then in the MainDash you load these qvds with the previously generated tables.

This way, you can show Reload times for any other app you need.

Another option would be like the previous comment says, to pass the reload time through a variable and then use a $(Include 😃 statement so the variable generated in a different document can be present in the actual one.

Greetings

adrianad
New Contributor III

Re: Is it possible to show the reload time from a different Dashboard?

Thank you Jaime!

kavicsgym
Contributor

Re: Is it possible to show the reload time from a different Dashboard?

If you put ReloadTime() at the very end of your script in App1, make a small table (with Autogenerate), store it into qvd or txt and load this table into another app (App2) during reload of App2 - this case you will get the previous (-1) ReloadTime() of App1, not the latest one.

Before the last reload of App1 completely finishes - so while the script is running -  ReloadTime() gives the previous reload timestamp. So you cannot get the timestamp of the currently running reload at the end of the script.

You can use now() in App1 script, but after that QV indexes the app and saves it and this takes up a few seconds. So now() and ReloadTime() - the one you get in the GUI after reload - will differ a couple of secs.

Am i not right?