topic Re: Using Action Select in Field with Concat in QlikView

Using Action Select in Field with Concat

Anonymous — Thu, 24 Sep 2015 16:55:34 GMT

I'm trying to select a field based on the selection of a different data table. I can get it to work as long as the selection doesnt have a space in it.

In the attached example of names, they all work except for 'John R'. That's the only one with a space. Is there a solution to this or do I need to remove all spaces from my data?

Re: Using Action Select in Field with Concat

maxgro — Thu, 24 Sep 2015 17:46:53 GMT

just add double quotes

='("'&Concat(Distinct Name1Value,'"|"')&'")'

//'('&Concat(Distinct Name1Value,'|')&')'

Re: Using Action Select in Field with Concat

Anonymous — Thu, 24 Sep 2015 17:57:07 GMT

Works thanks. What does the double quotes do and what determines placement of them?

Re: Using Action Select in Field with Concat

maxgro — Fri, 25 Sep 2015 07:08:04 GMT

double quotes?

when you have space in values, John R --> "John R"