6 Replies Latest reply: Nov 26, 2015 10:46 PM by Prashant Sangle RSS

    Loading scientific values from CSV



      i have a csv with values in scientific notation, for example:   5.15062E+12

      qhwn i open this CSV in EXCEL and change the cell format to Number i get this value: 5150615600780


      which is the correct value



      but when i load the CSV file into qlikview it loads in the E+ format 5.15062E+12

      and when i change it to number in the object properties NUMBERS tab

      it shows this:5150620000000


      how can i load it so it shows the correct value like in excel: 5150615600780