topic Search String for selection in QlikView https://community.qlik.com/t5/QlikView/Search-String-for-selection/m-p/557186#M207997 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I was wondering how to use the search string on a button, if i want to have all the ID of events occuring today.</P><P></P><P>For example i want the button to select todays date according to a date field on my database, and be able to select it, so i can show the ID of the events ocurring today preselected on a listbox.</P><P></P><P>Am i making myself clear?</P><P>Any ideas?</P><P></P><P>thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 06 Jan 2014 19:51:19 GMT 2014-01-06T19:51:19Z Search String for selection https://community.qlik.com/t5/QlikView/Search-String-for-selection/m-p/557186#M207997 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I was wondering how to use the search string on a button, if i want to have all the ID of events occuring today.</P><P></P><P>For example i want the button to select todays date according to a date field on my database, and be able to select it, so i can show the ID of the events ocurring today preselected on a listbox.</P><P></P><P>Am i making myself clear?</P><P>Any ideas?</P><P></P><P>thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 06 Jan 2014 19:51:19 GMT https://community.qlik.com/t5/QlikView/Search-String-for-selection/m-p/557186#M207997 2014-01-06T19:51:19Z Re: Search String for selection https://community.qlik.com/t5/QlikView/Search-String-for-selection/m-p/557187#M207998 <HTML><HEAD></HEAD><BODY><P>Select in Field:</P><P>ID</P><P></P><P>Search String:</P><P>='(' &amp; concat({&lt;DateField={'$(=date(today()))'}&gt;}distinct ID, '|') &amp; ')'</P></BODY></HTML> Mon, 06 Jan 2014 20:08:30 GMT https://community.qlik.com/t5/QlikView/Search-String-for-selection/m-p/557187#M207998 Nicole-Smith 2014-01-06T20:08:30Z Re: Search String for selection https://community.qlik.com/t5/QlikView/Search-String-for-selection/m-p/557188#M207999 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>PFA</P></BODY></HTML> Mon, 06 Jan 2014 20:09:23 GMT https://community.qlik.com/t5/QlikView/Search-String-for-selection/m-p/557188#M207999 MayilVahanan 2014-01-06T20:09:23Z