https://community.qlik.com/t5/QlikView/pivot-concat-with-filter/m-p/1586235#M740048 <P>Hello everybody</P><P>A very simple question for such&nbsp; experts as you are <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp;</P><P>How can I filter a 'concat' operation ? Let's see the attached example, I want to see only the fruit that has in their cycle the word "customer", therefore only the orange shall be visible.</P><P>Any idea ?</P><P>Thanks a lot</P><P>Marzio&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT marzio85 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/pivot-concat-with-filter/m-p/1586235#M740048 <P>Hello everybody</P><P>A very simple question for such&nbsp; experts as you are <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp;</P><P>How can I filter a 'concat' operation ? Let's see the attached example, I want to see only the fruit that has in their cycle the word "customer", therefore only the orange shall be visible.</P><P>Any idea ?</P><P>Thanks a lot</P><P>Marzio&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/pivot-concat-with-filter/m-p/1586235#M740048 marzio85 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/pivot-concat-with-filter/m-p/1586242#M740049 You could wrap a FindOneOf() around it.<BR /><BR /><A href="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/StringFunctions/FindOneOf.htm" target="_blank">https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/StringFunctions/FindOneOf.htm</A> Wed, 29 May 2019 14:04:52 GMT https://community.qlik.com/t5/QlikView/pivot-concat-with-filter/m-p/1586242#M740049 Vegar 2019-05-29T14:04:52Z