10 Replies Latest reply: Jul 26, 2014 4:20 AM by Neeraja Nagreddy RSS

    QV showing incorrect values - load

      Hi everyone;

      When I load data from SQL to Qlikview doesn't show the information correct in Qlik View for example

       

      if I have a 2 records:

      061277

      61277

      when I load this in qlikview show:

      061277

      061277

       

      I WAS trying the next and doesn't work:

      convert in sql or qlikview to varchar, char, text or money...

      also cut characters with function INDEX etc, etc....

       

      CAN YOU HELP PLEASE ANY IDEA?

       

      ACTUALLY Show records in SQL column t_item:

      sql2.jpg

       

      ACTUALLY Show records in QlikView column t_item:

      qlikview.jpg