Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
doplear01
Creator
Creator

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

0 Replies