3 Replies Latest reply: Feb 28, 2012 5:59 PM by terryj54 RSS

    Strange results from chr() function

      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