2 Replies Latest reply: Feb 19, 2018 9:02 AM by Miguel Angel Baeyens de Arce RSS

    QlikVIew is converting my text values into numbers? How to fix it?

    John Blomqvist

      Hello,

       

      I have a Excel column that looks like this:

       

      %
      <100%
      <50%
      50%
      80%
      >=75%
      >50%

       

      When I load it into QlikView it is converting 50%, 80%, 100% into 5, 8, and 1.

       

      QlikView is treating this field as Mixed.

       

      How can I stop it doing that?