topic Re: Help in QlikView

Help

fabio182 — Thu, 30 Oct 2014 20:39:46 GMT

Hi gays !!!!

I can help on how to convert this string

ALESE, AUTOLAND

'ALESE','AUTOLAND'

in set analisys please

Atte. Fabio

JonnyPoole — Thu, 30 Oct 2014 20:57:54 GMT

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...

maxgro — Thu, 30 Oct 2014 21:04:51 GMT

fabio182 — Thu, 30 Oct 2014 21:35:29 GMT

Thanks man.

fabio182 — Thu, 30 Oct 2014 21:35:44 GMT

Thanks man !!!

MarcoWedel — Thu, 30 Oct 2014 21:55:14 GMT

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

fabio182 — Thu, 30 Oct 2014 22:09:19 GMT

Thank's man

MarcoWedel — Thu, 30 Oct 2014 22:32:55 GMT

You're welcome

regards

Marco