topic Re: How to convert a string to number? in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-a-string-to-number/m-p/425745#M695902 <HTML><HEAD></HEAD><BODY><P>It might be that your Month_Date value needs to be converted to a proper date format first (after parsing it from the field selections) before you can convert it to a number?</P></BODY></HTML> Fri, 05 Apr 2013 09:32:11 GMT Anonymous 2013-04-05T09:32:11Z How to convert a string to number? https://community.qlik.com/t5/QlikView/How-to-convert-a-string-to-number/m-p/425744#M695901 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I want to display a text box when the date in another chart must be &lt; 03/04/2013.</P><P></P><P>For that I wrote a code under the <STRONG>Layout -&gt; Condtional Show </STRONG>of the Text box as below</P><P></P><P>=GetSelectedCount(Month_Date)&lt;&gt;0 or num(SubField(GetFieldSelections(Month_Date),',',-1))&lt;41366</P><P></P><P>but the String returned from <STRONG>SubField(GetFieldSelections(Month_Date),',',-1) </STRONG>could not convert to number format.</P><P></P><P>Anyone please help me...</P><P></P><P>Thanks in advance</P></BODY></HTML> Fri, 05 Apr 2013 09:29:30 GMT https://community.qlik.com/t5/QlikView/How-to-convert-a-string-to-number/m-p/425744#M695901 2013-04-05T09:29:30Z Re: How to convert a string to number? https://community.qlik.com/t5/QlikView/How-to-convert-a-string-to-number/m-p/425745#M695902 <HTML><HEAD></HEAD><BODY><P>It might be that your Month_Date value needs to be converted to a proper date format first (after parsing it from the field selections) before you can convert it to a number?</P></BODY></HTML> Fri, 05 Apr 2013 09:32:11 GMT https://community.qlik.com/t5/QlikView/How-to-convert-a-string-to-number/m-p/425745#M695902 Anonymous 2013-04-05T09:32:11Z