Qlik Community

QlikView Documents

QlikView documentation and resources.

Document boards are being consolidated, this board no longer allows NEW documents READ MORE

Audit Logging

Showing results for 
Search instead for 
Did you mean: 
Luminary Alumni
Luminary Alumni

Audit Logging



This is something I’ve used time and time again in organizations I’ve worked for. QlikView does automatically log information when using QMS, this is different…..

Within the script code is placed that will write to an ‘Audit Log’ qvd which can be read by a further dashboard (attached). All types of information can be passed and what is up to you. Variable states, table sizes, durations, etc. Anything that will help you later debug an issue or monitor the performance.

Benefits of implementing this code become apparent when monitoring script performance or debugging script issues that arise outside office hours (or at any time).

Here is a technical guide (Audit Logging | qlikcentral)

Hope it helps and I'd love to hear your feedback

Note - Some field values in the attached dashboard have been scrambled


qlikcentral | Create / Inform

Labels (2)
Creator II
Creator II

Hi Richard,

Thanks for this.  I have been playing with it today and managed to get it working (I wasn't entirely sure what I needed to configure.

Do you have an example of how you would deploy this into a script? i.e. how would you wrap it around a table you were loading/processing?

I'll let you know if I have any further feedback....



Luminary Alumni
Luminary Alumni

Hi Mike,

In my blog there's a number of code examples you can copy and paste into your application. For example:

**********Update start for audit log***********/

LET vAuditLog_Start = TimeStamp(Now());



Load * from


// Store the table size & Duration in audit log
/***************Update audit log****************/
LET vTable = ‘FACT_Table'; LET vRows  = NoOfRows(‘$(vTable)’);  LET vFields = NoOfFields(‘$(vTable)’);
CALL AuditLog (‘$(vCycleStart)’,’$(vAuditLog_Application)’,’QVD FACT Row Count’,’$(vTable)’,’$(vRows)’,’$(vAuditLog_Start)’);
CALL AuditLog (‘$(vCycleStart)’,’$(vAuditLog_Application)’,’QVD FACT Field Count’,’$(vTable)’,’$(vFields)’,’$(vAuditLog_Start)’);
CALL AuditLog (‘$(vCycleStart)’,’$(vAuditLog_Application)’,’Duration’,’$(vTable)’,”,’$(vAuditLog_Start)’);
LET vTable =; LET vRows  = ;  LET vFields = ;

This is how code is used around load statements to log how big the table was and how long it took to load.

If you follow the link to the technical guide about it will talk you through the other elements and code examples (although from your message I guess you may have already looked at that). Please let me know if you need any further help.



Version history
Last update:
‎2014-04-01 09:21 AM
Updated by: