0 Replies Latest reply: Sep 9, 2015 2:01 PM by german olivera RSS

    Create a vbscript function to format a number in load table

      How can i create a vbscript function that format a number? I need to use this function in a load statement

       

      something like this:

       

      /* in thevbscript */

      sub FormatFunction(field)

       

      FormatFunction = num#(Cost, '#.#', '.', ',')  

          

       

      en sub

       

      /* in the qlikview editor */

      TBL:

      Load

      FormatFunction(comision) AS Comision,

      FormatFunction(fee) AS Fee

      autogenerate(1);