Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
The ASCII character corresponding to number n. The result is a string.
chr( 65 ) returns the string 'A'.
You can try using "text" or don't even use a function at all
='PR'&text(ProjectID)&'-'&Project
or
='PR'&ProjectID&'-'&Project
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.
The ASCII character corresponding to number n. The result is a string.
chr( 65 ) returns the string 'A'.
You can try using "text" or don't even use a function at all
='PR'&text(ProjectID)&'-'&Project
or
='PR'&ProjectID&'-'&Project
chr() is the wrong function for this case. You want to use text().
='PR' & text(ProjectID) &'-'&Project
-Rob
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!