Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to set document properties by VBA?

I want to set 'Initial Data Reduction Based on ....' and 'Strict Exclusion' active status in one .qvw file by VBA. How can I write the script?

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

Hi John,

Sub Test

rem ** set initial data reduction by section access **

set docprop = ActiveDocument.GetProperties

docprop.DynamicReduceData = true

docprop.StrictDynamicReduction = true

ActiveDocument.SetProperties docprop


End Sub

View solution in original post

1 Reply
tamilarasu
Champion
Champion

Hi John,

Sub Test

rem ** set initial data reduction by section access **

set docprop = ActiveDocument.GetProperties

docprop.DynamicReduceData = true

docprop.StrictDynamicReduction = true

ActiveDocument.SetProperties docprop


End Sub