Question about searching within Concatenated field in expression

[dgreenberg]

I am not sure if I like the way this was done or not, I see benefits to both.

We have a chart that is showing something like this:

Restaurant	Years Reviewed
Applebees	2014|2015
Fridays	2012|2014
Red Lobster	2015

This is accomplished through a simple concatenation

Concat

([Review Year], ' | ')

//Forgive the weird formatting of the lines above it should be on 1 line.  Concat ([Review Year],'|')

So I like the way it looks in the chart but am not sure how to make it searchable the right way.  If you filter on Applebees and 2014 you would get this row:

Restaurant	Years Reviewed
Applebees	2014

What I expected and want is

Restaurant	Years Reviewed
Applebees	2014|2015

What are your thoughts on showing concatenated values in a chart and do you have thoughts on how to have the search or filter yield my expected results?

Thanks

Dan

[giakoum · Accepted solution]

Concat ({<Review Year=>}<[Review Year],'|')

this will disregard your year selection in the expression

[swuehl]

Maybe something like this:

if( count([Review Year]), concat({1} [Review Year], '|') )

[dgreenberg]

The obvious answer - thanks Ioannis.  My brain stopped working this afternoon.

Just have to remove the eroneous <

Concat ({<[Review Year]=>}[Review Year],'|')





//Concat ({<Review Year=>}<[Review Year],'|')

[giakoum]

sorry for the <!!

its Friday, time to relax