topic Re: Search for a string in a Field in QlikView https://community.qlik.com/t5/QlikView/Search-for-a-string-in-a-Field/m-p/704452#M1075134 <HTML><HEAD></HEAD><BODY><P>Hi Mirco</P><P></P><P>You can achieve this using Button and setting Action under it.</P><P></P><P>Create Button&gt; Properties</P><P>Actions&gt; Select in field</P><P>Field : Name</P><P>Search String : *Mirco*</P><P></P><P>See the Attachment.</P><P></P><P>Regards</P><P>Aviral Nag</P></BODY></HTML> Sun, 03 Aug 2014 19:12:25 GMT aveeeeeee7en 2014-08-03T19:12:25Z Search for a string in a Field https://community.qlik.com/t5/QlikView/Search-for-a-string-in-a-Field/m-p/704451#M1075133 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P></P><P>does anyone know how to search for a string in selected field? </P><P></P><P>I need to know the recurrence of a specific string in a selected field.</P><P></P><P>Thanks in advance</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Mirco</SPAN></P></BODY></HTML> Sun, 03 Aug 2014 18:57:40 GMT https://community.qlik.com/t5/QlikView/Search-for-a-string-in-a-Field/m-p/704451#M1075133 2014-08-03T18:57:40Z Re: Search for a string in a Field https://community.qlik.com/t5/QlikView/Search-for-a-string-in-a-Field/m-p/704452#M1075134 <HTML><HEAD></HEAD><BODY><P>Hi Mirco</P><P></P><P>You can achieve this using Button and setting Action under it.</P><P></P><P>Create Button&gt; Properties</P><P>Actions&gt; Select in field</P><P>Field : Name</P><P>Search String : *Mirco*</P><P></P><P>See the Attachment.</P><P></P><P>Regards</P><P>Aviral Nag</P></BODY></HTML> Sun, 03 Aug 2014 19:12:25 GMT https://community.qlik.com/t5/QlikView/Search-for-a-string-in-a-Field/m-p/704452#M1075134 aveeeeeee7en 2014-08-03T19:12:25Z Re: Search for a string in a Field https://community.qlik.com/t5/QlikView/Search-for-a-string-in-a-Field/m-p/704453#M1075135 <HTML><HEAD></HEAD><BODY><P>Hi Mirco, you can try using two functions -</P><P>getfieldselection - to get the field value selected</P><P>and </P><P>substringcount - to give frequency of the string you are searching for.</P><P></P><P>SubStringCount(GetFieldSelections(FIELD_NAME),'STRING_VALUE')</P></BODY></HTML> Sun, 03 Aug 2014 19:28:30 GMT https://community.qlik.com/t5/QlikView/Search-for-a-string-in-a-Field/m-p/704453#M1075135 2014-08-03T19:28:30Z