topic applymap? in QlikView https://community.qlik.com/t5/QlikView/applymap/m-p/713565#M1057202 <HTML><HEAD></HEAD><BODY><P>num#(applymap('tablename,fieldname) as&nbsp; newfield;</P><P></P><P>what num# will do here</P></BODY></HTML> Mon, 13 Oct 2014 13:43:24 GMT Anonymous 2014-10-13T13:43:24Z applymap? https://community.qlik.com/t5/QlikView/applymap/m-p/713565#M1057202 <HTML><HEAD></HEAD><BODY><P>num#(applymap('tablename,fieldname) as&nbsp; newfield;</P><P></P><P>what num# will do here</P></BODY></HTML> Mon, 13 Oct 2014 13:43:24 GMT https://community.qlik.com/t5/QlikView/applymap/m-p/713565#M1057202 Anonymous 2014-10-13T13:43:24Z Re: applymap? https://community.qlik.com/t5/QlikView/applymap/m-p/713566#M1057203 <HTML><HEAD></HEAD><BODY><P>This num# will convert into a number the result of your applyMap. </P><P></P><P>For more information about num#, take a look on qlikview Help.</P><P></P><P>Regards,</P><P>Gabriel</P></BODY></HTML> Mon, 13 Oct 2014 13:56:05 GMT https://community.qlik.com/t5/QlikView/applymap/m-p/713566#M1057203 Anonymous 2014-10-13T13:56:05Z Re: applymap? https://community.qlik.com/t5/QlikView/applymap/m-p/713567#M1057204 <HTML><HEAD></HEAD><BODY><P>the above expression is missing a ' and a ) fyi:</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">num#(applymap('tablename<STRONG>'</STRONG>,fieldname)<STRONG>)</STRONG> as&nbsp; newfield;</SPAN></P></BODY></HTML> Mon, 13 Oct 2014 13:57:59 GMT https://community.qlik.com/t5/QlikView/applymap/m-p/713567#M1057204 simondachstr 2014-10-13T13:57:59Z Re: applymap? https://community.qlik.com/t5/QlikView/applymap/m-p/713568#M1057205 <HTML><HEAD></HEAD><BODY><P> num# (expression [ , cod- format [ , sep - decimal [ , sep -miles ]]])</P><P>The num # function evaluates the expression numerically according to the supplied string as code format .</P></BODY></HTML> Mon, 13 Oct 2014 14:04:51 GMT https://community.qlik.com/t5/QlikView/applymap/m-p/713568#M1057205 Anonymous 2014-10-13T14:04:51Z