Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

fabio182
Contributor II

Help

Hi gays !!!!

I can help on how to convert this string

ALESE, AUTOLAND

in

'ALESE','AUTOLAND'

in set analisys please

Atte. Fabio

Tags (1)
1 Solution

Accepted Solutions
Employee
Employee

Re: Help

chr(39)  - single quote   AND chr(44) - comma   ...are your friends while using double quotes in your SET MODIFIER.

So something like this

sum( {<RegionString={"$(=chr(39) & 'North America' & chr(39) & chr(44) & chr(39) & 'South America' & chr(39))"}>}  Sales)

will evaluate to:

Sum ( {<RegionString={"  'North America','South America' "}>} Sales)

and only show the result where RegionString is:    'North America','South America'

as below...

Capture.PNG.png

View solution in original post

7 Replies
Employee
Employee

Re: Help

chr(39)  - single quote   AND chr(44) - comma   ...are your friends while using double quotes in your SET MODIFIER.

So something like this

sum( {<RegionString={"$(=chr(39) & 'North America' & chr(39) & chr(44) & chr(39) & 'South America' & chr(39))"}>}  Sales)

will evaluate to:

Sum ( {<RegionString={"  'North America','South America' "}>} Sales)

and only show the result where RegionString is:    'North America','South America'

as below...

Capture.PNG.png

View solution in original post

MVP
MVP

Re: Help

1.png

fabio182
Contributor II

Re: Help

Thanks man.

fabio182
Contributor II

Re: Help

Thanks man !!!

Re: Help

=Chr(39)&Replace('ALESE, AUTOLAND',',',Chr(39)&','&Chr(39))&Chr(39)

fabio182
Contributor II

Re: Help

Thank's man

Re: Help

You're welcome

regards

Marco