1 Reply Latest reply: Aug 31, 2017 12:00 PM by Steven Taschereau RSS

    QlikSense Auto sort handling of varchar fields.

    Steven Taschereau

      Hi All,

       

      I have a QlikSense app that is reading a SQL table which contains a column declared as varchar(19). 

       

      When I display the contents of this column in a QlikSense table visualization with sorting set to Auto the values are sorted by load order.


      My question is, since the source column is defined as varchar, shouldn't the Auto setting treat it as text and sort it alphabetically?


      If the column were defined as text instead of varchar,  or the SQL in my script cast the field to text, would Auto sorting then sort alphabetically?


      Thanks,

      Steve