concat function

[Anonymous]

Hi,

I have a question concerning a concat function. Let me give you an example.

There are three brands selected:

KIA

KIA CEE'D

KIA CERATO

I created a variable:

eDynamicTop=Concat({$} Distinct chr(39)Brands&chr(39), ',')

The result of this variable = 'KIA','KIA CEE'D','KIA CERATO'

Then I use this variable as an argument in the other expression.

match (only(Brands), $(eDynamicTop))

It doesn't work!

If I use chr(34), it doesn't work as well.

Is there a solution?

Thank you in advacne,

Larisa

[sunny_talwar]

What happens when you just select KIA and KIA CERATO? Does it then work? I am thinking that may be because you have single quote in KIA CEE'D, it might be interfering with your expression.

Can you share a sample?

Best,

Sunny

[Anonymous · Accepted solution]

It is certainly because of the single quote in the name.  The most reliable way is to get rid of this character on data load.  Otherwise, replace it with some unlikely string in the expressions, e.g.:

DynamicTop=Concat({$} Distinct chr(39)&replace(Brands,chr(39), 'AAA')&chr(39), ',')

=match (replace(Brands, chr(39), 'AAA'), $(eDynamicTop))

[Anonymous]

Thank you!

If KIA chooses to give the name 'KIA CEE'D', I shall not change it because of QlikView pecularities

[Anonymous]

I'd call it KIA peculiarities, but it's a subject open for discussion

(Full disclosure - I own a KIA myself, and have nothing against it, except the GPS software quality )