topic Macro to catch user-entered string ('Searchable' field) in QlikView https://community.qlik.com/t5/QlikView/Macro-to-catch-user-entered-string-Searchable-field/m-p/454675#M487542 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>This seems a bit tough to me as I am not very good at VBS. Basically I have been trying to catch a string the user enters to the Search field - and it is getting more complex, because I need to have the values of that tiny 'Searchable' field users may open on certain objects. In the screenshot below, for instance, I would need to get the value '&gt;77' as a string.</P><P></P><P><IMG __jive_id="31932" alt="catchfield.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/31932_catchfield.png" /></P><P></P><P>A good try was a code like this:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13590468907046758" jivemacro_uid="_13590468907046758"><P>currentSearchString = ActiveDocument.Evaluate("GetFieldSelections(Suppliers)")</P></PRE><P>which, however, only returns the Supplier names, not the filter expression.</P><P></P><P>The next big thing I am trying to figure out is <STRONG>where </STRONG>to 'listen' for the event of users typing in values.</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 24 Jan 2013 16:53:11 GMT 2013-01-24T16:53:11Z Macro to catch user-entered string ('Searchable' field) https://community.qlik.com/t5/QlikView/Macro-to-catch-user-entered-string-Searchable-field/m-p/454675#M487542 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>This seems a bit tough to me as I am not very good at VBS. Basically I have been trying to catch a string the user enters to the Search field - and it is getting more complex, because I need to have the values of that tiny 'Searchable' field users may open on certain objects. In the screenshot below, for instance, I would need to get the value '&gt;77' as a string.</P><P></P><P><IMG __jive_id="31932" alt="catchfield.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/31932_catchfield.png" /></P><P></P><P>A good try was a code like this:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13590468907046758" jivemacro_uid="_13590468907046758"><P>currentSearchString = ActiveDocument.Evaluate("GetFieldSelections(Suppliers)")</P></PRE><P>which, however, only returns the Supplier names, not the filter expression.</P><P></P><P>The next big thing I am trying to figure out is <STRONG>where </STRONG>to 'listen' for the event of users typing in values.</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 24 Jan 2013 16:53:11 GMT https://community.qlik.com/t5/QlikView/Macro-to-catch-user-entered-string-Searchable-field/m-p/454675#M487542 2013-01-24T16:53:11Z