Hi there,
I have 1 row per person, with a column for a concatenated list of colours....eg.
PersonColour
FredRed, Blue, GreenFrankRedGeorgeRed, Blue
I would like to have a filter, where I can choose "Red" to show all three people, "Blue" to show Fred and George and "Green" to show only Fred.
But how to create a filter that pulls apart the concatenated values.
TIA Matt
Another Option 1 :
Having multiple Parameters to filter them
Another Option 2:
Using Split function to Filter using one Parameterif
contains([Concat Colours],trim(split([Filter Parameter],";",1)) )
then
"True"
ELSEIF len(split([Filter Parameter],";",2)) > 0
AND contains([Concat Colours],trim(split([Filter Parameter],";",2)) ) then
"True"
ELSEIF len(split([Filter Parameter],";",3)) > 0
AND contains([Concat Colours],trim(split([Filter Parameter],";",3)) ) then
"True"
ELSEIF len(split([Filter Parameter],";",4)) > 0
AND contains([Concat Colours],trim(split([Filter Parameter],";",4)) ) then
"True"
ELSEIF len(split([Filter Parameter],";",5)) > 0
AND contains([Concat Colours],trim(split([Filter Parameter],";",5)) ) then
"True"
END
; helps to make multiple list and above formula can help up to 5 values, if u need more, just copy the last lines and add 6 , 7 to it.
