https://community.qlik.com/t5/QlikView/SubstringCount-with-GetFieldSelection/m-p/1795234#M1211129 <P>Hi all</P><P>My current expression is</P><P>If(substringCount( GetFieldSelections(Batches_to_Include,'|',100) &amp; Batch)&gt;0,vHighLightNewBatchesColour,LightGray())</P><P>my Batches_to_Include field contains&nbsp;</P><P>AA1234</P><P>AA5678</P><P>AB1234</P><P>AB5678</P><P>&nbsp;</P><P>My Batch Field contains</P><P>the same batches and thus the expression finds all the same batches and colours accordingly</P><P>&nbsp;</P><P>However, if I have batch in the Batch Field called AC3564, AB1234, the expression doesn't find AB1234</P><P>How can I incorporate a Like into the expression , so the expression will look for *AB1234* in the Batch Field.</P><P>&nbsp;</P><P>Regards</P><P>Many thanks for looking</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 29 Mar 2021 09:39:28 GMT spikenaylor1 2021-03-29T09:39:28Z https://community.qlik.com/t5/QlikView/SubstringCount-with-GetFieldSelection/m-p/1795234#M1211129 <P>Hi all</P><P>My current expression is</P><P>If(substringCount( GetFieldSelections(Batches_to_Include,'|',100) &amp; Batch)&gt;0,vHighLightNewBatchesColour,LightGray())</P><P>my Batches_to_Include field contains&nbsp;</P><P>AA1234</P><P>AA5678</P><P>AB1234</P><P>AB5678</P><P>&nbsp;</P><P>My Batch Field contains</P><P>the same batches and thus the expression finds all the same batches and colours accordingly</P><P>&nbsp;</P><P>However, if I have batch in the Batch Field called AC3564, AB1234, the expression doesn't find AB1234</P><P>How can I incorporate a Like into the expression , so the expression will look for *AB1234* in the Batch Field.</P><P>&nbsp;</P><P>Regards</P><P>Many thanks for looking</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 29 Mar 2021 09:39:28 GMT https://community.qlik.com/t5/QlikView/SubstringCount-with-GetFieldSelection/m-p/1795234#M1211129 spikenaylor1 2021-03-29T09:39:28Z https://community.qlik.com/t5/QlikView/SubstringCount-with-GetFieldSelection/m-p/1805618#M1212071 <P>What is that you are trying to accomplish by using the expression? By default anything not selected will not be shown in any chart. You would need to use some Set Analysis to get data you haven't selected to be visualized.&nbsp;</P> Wed, 05 May 2021 18:56:13 GMT https://community.qlik.com/t5/QlikView/SubstringCount-with-GetFieldSelection/m-p/1805618#M1212071 Dalton_Ruer 2021-05-05T18:56:13Z