Qlik App Reload Telemetry

This code is useful for capturing reload statistics in a single app:

• reload start and end time

• reload duration

• user executing the reload

• computer executing the reload

Sure, you could use the Qlik Management Console (QMC) to view reload statistics, however, not all users have access and maybe you are not familiar enough with the QMC to find the information you want.

The following blocks of script are placed at the very start ( right after any binary load) and the very end of a Qlik app. This example only captures the last reload, for history you would need to store the data in a QVD or similar.

The first block captures the reload start time, this is why it should be as near as the first line of executed script as possible.

/*

Logic to capture model telemetry i.e reload time, computer and user

*/

//Following line goes on the very first tab - usually the Main tab
// Capture time reload starts for telemetry
Let vReloadStart = Now();

The second block of code goes at the very end of the script. Logically, this would be a separate tab (QlikView) or section (Qlik Sense).

After you reload the app an orphaned table called Telemetry will be visible.

/*

Compile telemetry data into a table that can be referenced if required

This will appear as an orphan in the data model

*/

// Update variable to capture reload end time
Let vReloadEnd = Now();
Let vReloadDuration = Interval ( Date ( '$(vReloadEnd)' ) - Date ( '$(vReloadStart)' ), 'hh:mm:ss' );


// Build metadata summary
[Telemetry]:
Load

	'$(vReloadStart)'				As [Reload start time],
	'$(vReloadEnd)'					As [Reload end time],
	'$(vReloadDuration)'			As [Reload duration],
	OSUser()						As [Reload user],
	ComputerName()					As [Reload machine]
	
AutoGenerate 1;