Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

How to disable Lineage information in QlikView QVD files

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
ToniKautto
Employee
Employee

How to disable Lineage information in QlikView QVD files

Last Update:

Mar 9, 2021 6:50:27 AM

Updated By:

Sonja_Bauernfeind

Created date:

May 7, 2013 3:09:55 PM

QlikView QVD files contain lineage information of the stored data. 

 

Environment:

QlikView any version

 

The lineage information can be found in the QVD file XML header and might look like below, with connection details and the SQL statements used during reload. 

Lineage.png

 

Resolution:

The lineage information can be suppressed as follows:
 
Setting in QlikView Desktop client
  1. Open Qlikview Desktop client 
  2. Go to Help > About Qlikview...
  3. Right click the QlikView logo in the bottom right corner
  4. Highlight the AllowDataLineage value
  5. Set the value to -1 to disable the Lineage information
  6. Click Set to store the value change
  7. Close the settings and about dialog boxes
  8. Reload the QVD generator application

Setting on QlikView Server
  1. Open the QlikView Server’s batch settings.ini file in a text editor. Default file path; C:\Windows\System32\config\systemprofile\AppData\Roaming\QlikTech\QlikViewBatch\Settings.ini
  2. Add AllowDataLineage=-1 in the [Settings 7] section of the settings file. 
  3. Save the settings file and close text editor
  4. Restart QlikView Server, to trigger loading of the altered settings 
  5. Reload the QVW file from QlikView management console to see that the setting has been changed
  6. To enable the lineage information follow the steps above, but set the Value to 0 instead of -1 in step 5.
 
 
NOTE:

The setting is not deployed permanent and will be removed by product upgrades.

 

Labels (1)
Contributors
Version history
Last update:
‎2021-03-09 06:50 AM
Updated by: