Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
jaime_aguilar
New Contributor III

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

5 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.

jaime_aguilar
New Contributor III

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!

Community Browser