topic searchable value with macro in QlikView https://community.qlik.com/t5/QlikView/searchable-value-with-macro/m-p/160290#M34612 <HTML><HEAD></HEAD><BODY><P>What do you mean by calculated?</P><P>In order to make a selection, there has to be an underlying field to select on.</P></BODY></HTML> Wed, 02 Dec 2009 00:44:52 GMT 2009-12-02T00:44:52Z searchable value with macro https://community.qlik.com/t5/QlikView/searchable-value-with-macro/m-p/160287#M34609 <HTML><HEAD></HEAD><BODY><P>I need to select from straight table only these rows where column value is yes and after that I export the data to Excel. I made that column searchable and its work perfect if I write value in searchable box. But in future this file will work automatically and I must do the searchable thing with macro. Can anybody give me some hints how to do it? Thanks!</P></BODY></HTML> Fri, 20 Nov 2009 19:37:31 GMT https://community.qlik.com/t5/QlikView/searchable-value-with-macro/m-p/160287#M34609 2009-11-20T19:37:31Z searchable value with macro https://community.qlik.com/t5/QlikView/searchable-value-with-macro/m-p/160288#M34610 <HTML><HEAD></HEAD><BODY><P>You can make a direct selection using:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">ActiveDocument.Fields("FIELD").Select "*SEARCH*", true</PRE></BLOCKQUOTE><BR /><BR /> <P>If you can put your search value into a variable, you can use:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">searchVal = ActiveDocument.Variables("vTest").GetContent.String<BR /> ActiveDocument.Fields("FIELD").Select "*" &amp; searchVal &amp; "*", true</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Fri, 20 Nov 2009 21:46:34 GMT https://community.qlik.com/t5/QlikView/searchable-value-with-macro/m-p/160288#M34610 2009-11-20T21:46:34Z searchable value with macro https://community.qlik.com/t5/QlikView/searchable-value-with-macro/m-p/160289#M34611 <HTML><HEAD></HEAD><BODY><P>But what do to when the FIELD is not database field but calculated?</P></BODY></HTML> Tue, 01 Dec 2009 16:35:19 GMT https://community.qlik.com/t5/QlikView/searchable-value-with-macro/m-p/160289#M34611 2009-12-01T16:35:19Z searchable value with macro https://community.qlik.com/t5/QlikView/searchable-value-with-macro/m-p/160290#M34612 <HTML><HEAD></HEAD><BODY><P>What do you mean by calculated?</P><P>In order to make a selection, there has to be an underlying field to select on.</P></BODY></HTML> Wed, 02 Dec 2009 00:44:52 GMT https://community.qlik.com/t5/QlikView/searchable-value-with-macro/m-p/160290#M34612 2009-12-02T00:44:52Z