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

    german olivera

      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 */



      FormatFunction(comision) AS Comision,

      FormatFunction(fee) AS Fee