Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this
Concat({<Animal = {"=Concat(Colour) = 'BlackWhiteGrey' "}>}Colour)
Great Sunny..sorry for delay but this works fine!