topic Apply same filter in vbscript in QlikView https://community.qlik.com/t5/QlikView/Apply-same-filter-in-vbscript/m-p/336919#M124218 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>in vbscript i'd like to apply the same filter defined one a dimension on an other dimension.</P><P></P><P><SPAN style="text-decoration: underline;">Example: </SPAN></P><P></P><P>Active selection</P><P>DTFAB : &gt;200112</P><P> I want to apply exactly the same filter on an other dimension</P><P>DTRET : &gt;200112</P><P></P><P>Because when I do that</P><TABLE><TBODY><TR><TD></TD><TD>Set x = ActiveDocument.Fields("DTFAB").GetPossibleValues</TD></TR></TBODY></TABLE><P>&nbsp;&nbsp;&nbsp; Activedocument.Fields("DTRET").SelectValues x</P><P></P><P>It don't apply &gt;200112 but all the values of DTFAB (200201, 200203...) and it's not the same if months are missing</P><P></P><P>Thank you</P></BODY></HTML> Fri, 03 Aug 2012 12:58:57 GMT 2012-08-03T12:58:57Z Apply same filter in vbscript https://community.qlik.com/t5/QlikView/Apply-same-filter-in-vbscript/m-p/336919#M124218 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>in vbscript i'd like to apply the same filter defined one a dimension on an other dimension.</P><P></P><P><SPAN style="text-decoration: underline;">Example: </SPAN></P><P></P><P>Active selection</P><P>DTFAB : &gt;200112</P><P> I want to apply exactly the same filter on an other dimension</P><P>DTRET : &gt;200112</P><P></P><P>Because when I do that</P><TABLE><TBODY><TR><TD></TD><TD>Set x = ActiveDocument.Fields("DTFAB").GetPossibleValues</TD></TR></TBODY></TABLE><P>&nbsp;&nbsp;&nbsp; Activedocument.Fields("DTRET").SelectValues x</P><P></P><P>It don't apply &gt;200112 but all the values of DTFAB (200201, 200203...) and it's not the same if months are missing</P><P></P><P>Thank you</P></BODY></HTML> Fri, 03 Aug 2012 12:58:57 GMT https://community.qlik.com/t5/QlikView/Apply-same-filter-in-vbscript/m-p/336919#M124218 2012-08-03T12:58:57Z