9 Replies Latest reply: Nov 3, 2010 12:15 PM by IMQ_QLIKVIEW IMQ_QLIKVIEW RSS

    number format

      I am loading world population data from wikipedia.

      there's 1 table on the page, fine. it loads allright.

      but: numers are in USA format - where comma separates thousands.

       

      1,585,230 is tretated correctly as 1 million 585 thusand 230.

      3,149 (which means 3 thousand 149) is treated as 3 and 14 hundreds!

       

      This corrups totals, sums, averages and so on.

       

      Please help!

       

      /Dmitri