2 Replies Latest reply: May 12, 2017 7:02 AM by Nicolò Cogno RSS

    Problems loadind special characters

    Nicolò Cogno

      Hi everybody,

       

      I saw that trying to load fields that contains data with characters like '&' makes Qlik Sense truncate the row and it reads only what follows the special character. I also found out that this doesn't happen if the Excel data are text formatted, but I can't change the Excel original file and I'd like to know if there's a way to tell Qlik Sense to load Excel files formatting everything like text (using just Text() doesn't work).

       

      I saw some old threads about this, I hope somebody knows how to solve my problem!

       

      Thanks a lot to everybody in advance,

       

      Best regards

       

      Nicolò Cogno