Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
doplear01
New Contributor III

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);