Filter on Concat Expression in Pivot

[Anonymous]

Hi

QlikView 11.2.13x  64 bit

Data:

Animal	Colour
Dog	Black
Dog	White
Dog	Grey
Cat	Black
Cat	White
Mouse	Black
Mouse	White
Mouse	Grey

Pivot:

                                        Expression

Dimension: Animal               =Concat(Colour)

Result:

Animal          Expression

Dog              BlackWhiteGrey

Cat               BlackWhite

Mouse          BlackWhiteGrey    

I would like to be able to select BlackWhiteGrey and get:

Animal          Expression

Dog              BlackWhiteGrey

Mouse          BlackWhiteGrey    

Have tried:

=concat({$<concat(Colour)={"BlackWhiteGrey"}>}Colour)

Thanks.

[sunny_talwar]

May be this

Concat({<Animal = {"=Concat(Colour) = 'BlackWhiteGrey' "}>}Colour)

[Anonymous]

Great Sunny..sorry for delay but this works fine!