topic Re: Script Num format help! in QlikView https://community.qlik.com/t5/QlikView/Script-Num-format-help/m-p/33854#M772990 <HTML><HEAD></HEAD><BODY><P>nice one! thanks!</P></BODY></HTML> Tue, 15 May 2018 09:01:41 GMT hopkinsc 2018-05-15T09:01:41Z Script Num format help! https://community.qlik.com/t5/QlikView/Script-Num-format-help/m-p/33851#M772987 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>i have the attached script, the period field is coming through ina&nbsp; text format, so i am trying to change it to a num format in the script (so it links to other data correctly) but when i do that it doesnt load any values for the field. </P><P></P><P>I have commented out lines 72-80 which does the NUM change so you can see the text format working. </P><P></P><P>Any chance someone could take a look to see what i am doing wrong please?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Script-Num-format-help/m-p/33851#M772987 hopkinsc 2020-11-25T16:16:04Z Re: Script Num format help! https://community.qlik.com/t5/QlikView/Script-Num-format-help/m-p/33852#M772988 <HTML><HEAD></HEAD><BODY><P>Try using trim() like:</P><P></P><P>Num(<STRONG>trim</STRONG>(Period))&nbsp; as Period</P></BODY></HTML> Tue, 15 May 2018 08:59:14 GMT https://community.qlik.com/t5/QlikView/Script-Num-format-help/m-p/33852#M772988 tresB 2018-05-15T08:59:14Z Re: Script Num format help! https://community.qlik.com/t5/QlikView/Script-Num-format-help/m-p/33853#M772989 <HTML><HEAD></HEAD><BODY><P>In fact trim() alone should work, like :</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">trim</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">(Period)&nbsp; as Period</SPAN></P></BODY></HTML> Tue, 15 May 2018 09:00:39 GMT https://community.qlik.com/t5/QlikView/Script-Num-format-help/m-p/33853#M772989 tresB 2018-05-15T09:00:39Z Re: Script Num format help! https://community.qlik.com/t5/QlikView/Script-Num-format-help/m-p/33854#M772990 <HTML><HEAD></HEAD><BODY><P>nice one! thanks!</P></BODY></HTML> Tue, 15 May 2018 09:01:41 GMT https://community.qlik.com/t5/QlikView/Script-Num-format-help/m-p/33854#M772990 hopkinsc 2018-05-15T09:01:41Z