topic Re: Filter on Concat Expression in Pivot in QlikView https://community.qlik.com/t5/QlikView/Filter-on-Concat-Expression-in-Pivot/m-p/1412725#M427066 <HTML><HEAD></HEAD><BODY><P>Great Sunny..sorry for delay but this works fine!</P></BODY></HTML> Fri, 12 Jan 2018 09:07:00 GMT Anonymous 2018-01-12T09:07:00Z Filter on Concat Expression in Pivot https://community.qlik.com/t5/QlikView/Filter-on-Concat-Expression-in-Pivot/m-p/1412723#M427064 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>QlikView 11.2.13x&nbsp; 64 bit</P><P>Data:</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="128"><TBODY><TR><TD height="17" width="64">Animal</TD><TD width="64">Colour</TD></TR><TR><TD height="17">Dog</TD><TD>Black</TD></TR><TR><TD height="17">Dog</TD><TD>White</TD></TR><TR><TD height="17">Dog</TD><TD>Grey</TD></TR><TR><TD height="17">Cat</TD><TD>Black</TD></TR><TR><TD height="17">Cat</TD><TD>White</TD></TR><TR><TD height="17">Mouse</TD><TD>Black</TD></TR><TR><TD height="17">Mouse</TD><TD>White</TD></TR><TR><TD height="17">Mouse</TD><TD>Grey</TD></TR></TBODY></TABLE><P></P><P>Pivot:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Expression</P><P>Dimension: Animal&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =Concat(Colour)</P><P></P><P>Result:</P><P></P><P>Animal&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Expression</P><P>Dog&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BlackWhiteGrey</P><P>Cat&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BlackWhite</P><P>Mouse&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BlackWhiteGrey&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>I would like to be able to select BlackWhiteGrey and get:</P><P></P><P></P><P>Animal&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Expression</P><P>Dog&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BlackWhiteGrey</P><P>Mouse&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BlackWhiteGrey&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>Have tried:</P><P>=concat({$&lt;concat(Colour)={"BlackWhiteGrey"}&gt;}Colour)</P><P></P><P>Thanks.</P></BODY></HTML> Fri, 01 Dec 2017 14:11:32 GMT https://community.qlik.com/t5/QlikView/Filter-on-Concat-Expression-in-Pivot/m-p/1412723#M427064 Anonymous 2017-12-01T14:11:32Z Re: Filter on Concat Expression in Pivot https://community.qlik.com/t5/QlikView/Filter-on-Concat-Expression-in-Pivot/m-p/1412724#M427065 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Concat({&lt;Animal = {"=Concat(Colour) = 'BlackWhiteGrey' "}&gt;}Colour)</STRONG></P></BODY></HTML> Fri, 01 Dec 2017 17:03:23 GMT https://community.qlik.com/t5/QlikView/Filter-on-Concat-Expression-in-Pivot/m-p/1412724#M427065 sunny_talwar 2017-12-01T17:03:23Z Re: Filter on Concat Expression in Pivot https://community.qlik.com/t5/QlikView/Filter-on-Concat-Expression-in-Pivot/m-p/1412725#M427066 <HTML><HEAD></HEAD><BODY><P>Great Sunny..sorry for delay but this works fine!</P></BODY></HTML> Fri, 12 Jan 2018 09:07:00 GMT https://community.qlik.com/t5/QlikView/Filter-on-Concat-Expression-in-Pivot/m-p/1412725#M427066 Anonymous 2018-01-12T09:07:00Z