topic Re: How to set document properties by VBA? in QlikView https://community.qlik.com/t5/QlikView/How-to-set-document-properties-by-VBA/m-p/1433521#M798511 <HTML><HEAD></HEAD><BODY><P>Hi John,</P><P></P><P><STRONG>Sub Test</STRONG></P><P></P><P><SPAN style="font-size: 10pt;">rem ** set initial data reduction by section access **</SPAN></P><P>set docprop = ActiveDocument.GetProperties</P><P>docprop.DynamicReduceData = true</P><P>docprop.StrictDynamicReduction = true</P><P>ActiveDocument.SetProperties docprop</P><P><STRONG style="font-size: 10pt;"><BR /></STRONG></P><P><STRONG style="font-size: 10pt;">End Sub</STRONG></P></BODY></HTML> Wed, 06 Dec 2017 03:11:40 GMT tamilarasu 2017-12-06T03:11:40Z How to set document properties by VBA? https://community.qlik.com/t5/QlikView/How-to-set-document-properties-by-VBA/m-p/1433520#M798510 <HTML><HEAD></HEAD><BODY><P>I want to set '<STRONG>Initial Data Reduction Based on ....</STRONG>' and '<STRONG>Strict Exclusion</STRONG>' active status in one .qvw file by VBA. How can I write the script?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-set-document-properties-by-VBA/m-p/1433520#M798510 Anonymous 2020-11-25T16:16:04Z Re: How to set document properties by VBA? https://community.qlik.com/t5/QlikView/How-to-set-document-properties-by-VBA/m-p/1433521#M798511 <HTML><HEAD></HEAD><BODY><P>Hi John,</P><P></P><P><STRONG>Sub Test</STRONG></P><P></P><P><SPAN style="font-size: 10pt;">rem ** set initial data reduction by section access **</SPAN></P><P>set docprop = ActiveDocument.GetProperties</P><P>docprop.DynamicReduceData = true</P><P>docprop.StrictDynamicReduction = true</P><P>ActiveDocument.SetProperties docprop</P><P><STRONG style="font-size: 10pt;"><BR /></STRONG></P><P><STRONG style="font-size: 10pt;">End Sub</STRONG></P></BODY></HTML> Wed, 06 Dec 2017 03:11:40 GMT https://community.qlik.com/t5/QlikView/How-to-set-document-properties-by-VBA/m-p/1433521#M798511 tamilarasu 2017-12-06T03:11:40Z