2 Replies Latest reply: Aug 15, 2012 6:16 AM by Andreas Karlsson RSS

    Script fails since large numbers are presented with exponentials as e+008

    Andreas Karlsson

      Hi Folks,

      I have a dilemma with this row in my script.

       

      Concatenate (TestCycl_tmp) LOAD
       $(vMaxTCyId)*100+TC_TESTCYCL_ID as TC_TESTCYCL_ID,
      
      

       

      The variable is created like this

      Let vMaxTCyId=peek('TC_TESTCYCL_ID', -1,'maxTable');
      

       

      In QV11 things work as expected and the log file shows

      -------------------------------------------------------

      Concatenate (TestCycl_tmp) LOAD

                      228141244*100+TC_TESTCYCL_ID as TC_TESTCYCL_ID,

      -------------------------------------------------------

       

      in QV9 it fails and the log looks like

      ------------------------------------------------

      Concatenate (TestCycl_tmp) LOAD

                     2,2814124e+008*100+TC_TESTCYCL_ID as TC_TESTCYCL_ID,

      -------------------------------------------------

       

      The problem is the , (comma) making Qlikview generating a column with just the digit 2.

      So how do I force QV9 to present the number with only figures and not exponentials?

       

      brgds

      Andy