Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
num#(applymap('tablename,fieldname) as newfield;
what num# will do here
This num# will convert into a number the result of your applyMap.
For more information about num#, take a look on qlikview Help.
Regards,
Gabriel
This num# will convert into a number the result of your applyMap.
For more information about num#, take a look on qlikview Help.
Regards,
Gabriel
the above expression is missing a ' and a ) fyi:
num#(applymap('tablename',fieldname)) as newfield;
num# (expression [ , cod- format [ , sep - decimal [ , sep -miles ]]])
The num # function evaluates the expression numerically according to the supplied string as code format .