2 Replies Latest reply: Oct 4, 2018 6:54 AM by David Young RSS

    Spaces in Fields of Chart being dropped.

    David Young

      I have a field being pulled out of a Sql DB.  The name of the field in Invoice.  It is stored in the DB as VarChar.  So I am loading it with the following:

       

      load *

      Select Ven_ID

      ,Invoice

      From $(sDBName).dbo.Invoices i;

       

      So in the SQL DB Invoice appears like 111 234  and when it is render in Chart it appears like 111234. 

       

      Now I thought that Qlik Sense only removed the space on a Number field so you have to use the Text Function.  I cant find anything about VarChar or how to fix it.  Any help is welcome.

       

      Thanks,

      David