topic Strange results from chr() function in QlikView

Strange results from chr() function

Tue, 28 Feb 2012 20:59:18 GMT

I am trying to create a list box which contains an expression to represent a ProjectID plus the Project Name. An example would be: "PR265-Data Center Virtualization Phase 3" The expression syntax is: ='PR'&char(ProjectID)&'-'&Project This seems to work except that the chr(ProjectID) is displayed as a high-ASCII character, such as a non-english character with accents, not the number I expected. Data is drawn from a SQL Server 2005 db. The field ProjectID is of type "int". I am totally new to QlikView so an help or reference to where I should look would be greatly appreciated. Thanks! Terry

Re: Strange results from chr() function

phersan_sme — Tue, 28 Feb 2012 21:11:11 GMT

if you look at the definition of the function CHR from the help menu, you'll realize this isn't the function you want to use.

chr( n )

The ASCII character corresponding to number n. The result is a string.

Example:

chr( 65 ) returns the string 'A'.

You can try using "text" or don't even use a function at all

='PR'&text(ProjectID)&'-'&Project

='PR'&ProjectID&'-'&Project

Strange results from chr() function

rwunderlich — Tue, 28 Feb 2012 21:14:06 GMT

chr() is the wrong function for this case. You want to use text().

='PR' & text(ProjectID) &'-'&Project

-Rob

http://robwunderlich.com

Strange results from chr() function

Tue, 28 Feb 2012 22:59:59 GMT

Thanks Phersan and Rob for the excellent and very prompt help. I begin to see why I have heard others rave about how good the community support is for this product!