Spaces in Fields of Chart being dropped.

[davidvikings198]

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

[Nicole-Smith · Accepted solution]

You can try loading it in and casting it as text in the load script:

LOAD Ven_ID, TEXT(Invoice) AS Invoice;
SELECT Ven_ID,
     Invoice
From $(sDBName).dbo.Invoices i;

[davidvikings198]

Thank you Nicole.  I was going to do that but thought it was only for a Number field. 

David