topic Re: Question about searching within Concatenated field in expression in QlikView

Question about searching within Concatenated field in expression

dgreenberg — Fri, 19 Jun 2015 15:57:42 GMT

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

Re: Question about searching within Concatenated field in expression

giakoum — Fri, 19 Jun 2015 16:02:09 GMT

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

this will disregard your year selection in the expression

Re: Question about searching within Concatenated field in expression

swuehl — Fri, 19 Jun 2015 16:07:44 GMT

Maybe something like this:

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

Re: Question about searching within Concatenated field in expression

dgreenberg — Fri, 19 Jun 2015 16:08:02 GMT

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],'|')

Re: Question about searching within Concatenated field in expression

giakoum — Fri, 19 Jun 2015 16:09:45 GMT

sorry for the <!!

its Friday, time to relax