19 Replies Latest reply: Oct 11, 2011 4:49 AM by Stefan Wühl RSS

    Big numbers not loading as numbers

    Eon Alers

      Hi

       

       

       

       

       

       

       

       

       

      I've got a very strange problem. One of my data sources have quite a large number in it, lets call it longNum (10735136080000000.000000). My load script is this: (precision can be anything from 0 to 9)

       

      if(precision = 0,longNum,longNum/(pow(10,precision))) as field1,

       

       

      In QlikView field1 is now empty... Any idea how to fix this? I can bring in the field as a string but as soon as I try to do the division it breaks again.

      Your help will be appreciated!!