https://community.qlik.com/t5/QlikView/Multiple-ID-Search/m-p/1773440#M717972 <P>If it helps, as a workaround you can use 'toggle select' action and users can add values one by one, it that case you can use =Num($(vID),'0000000') as value for toggle select.</P> Mon, 11 Jan 2021 16:48:41 GMT rubenmarin 2021-01-11T16:48:41Z https://community.qlik.com/t5/QlikView/Multiple-ID-Search/m-p/1773346#M717971 <P>I have a field 'ID' which has 7 digit number format eg. 1234512, 0234512, 0003456, 0000312.</P><P>I'm using an Input box &amp; a Search button to add a functionality to search multiple IDs at a time.</P><P>InputBox is associated with var vID &amp; 'Select in Field' action added added on button for 'ID' field with value&nbsp; ='('&amp;replace(replace(vID, ',' ,''),' ', '|')&amp;')'&nbsp; (User enters text "1234512, 0234512, 0003456 " which is converted in format&nbsp; "(1234512|0234512|0003456)"</P><P>Now, this works perfectly fine if user enters a 7 digit number. But, how can we modify this to search an ID without any leading zeros. eg, 1117,345 instead of 0001117,0000345</P> Mon, 11 Jan 2021 12:37:23 GMT https://community.qlik.com/t5/QlikView/Multiple-ID-Search/m-p/1773346#M717971 pooja_sn 2021-01-11T12:37:23Z https://community.qlik.com/t5/QlikView/Multiple-ID-Search/m-p/1773440#M717972 <P>If it helps, as a workaround you can use 'toggle select' action and users can add values one by one, it that case you can use =Num($(vID),'0000000') as value for toggle select.</P> Mon, 11 Jan 2021 16:48:41 GMT https://community.qlik.com/t5/QlikView/Multiple-ID-Search/m-p/1773440#M717972 rubenmarin 2021-01-11T16:48:41Z