topic Re: Converting text field to number in QlikView https://community.qlik.com/t5/QlikView/Converting-text-field-to-number/m-p/778528#M1032369 <HTML><HEAD></HEAD><BODY><P>WeekDates contains dates from the start of the wee to the end e.g 01-07 then months contains the month of the current selected week</P><P></P><P>Listbox will look like this</P><P>02-08 Mar</P><P>05-11 Jan</P><P>19-25 Jan...etc</P><P></P><P>I want to sot the list box to have months in a cronological order</P></BODY></HTML> Wed, 28 Jan 2015 08:25:28 GMT 2015-01-28T08:25:28Z Converting text field to number https://community.qlik.com/t5/QlikView/Converting-text-field-to-number/m-p/778525#M1032366 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P> I have two fields which I would like to concatenate and convert to number so that I can easily sort the field</P><P></P><P>Script:</P><P><SPAN style="color: #0000ff;">Load</SPAN> <SPAN style="color: #ff6600;">WeeksDate</SPAN>&amp;''&amp;<SPAN style="color: #ff6600;">WeekMonth</SPAN> <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #ff6600;">WeekDateMonth</SPAN></P><P>From TableName</P><P></P><P>How can I do this?</P></BODY></HTML> Wed, 28 Jan 2015 08:03:59 GMT https://community.qlik.com/t5/QlikView/Converting-text-field-to-number/m-p/778525#M1032366 2015-01-28T08:03:59Z Re: Converting text field to number https://community.qlik.com/t5/QlikView/Converting-text-field-to-number/m-p/778526#M1032367 <HTML><HEAD></HEAD><BODY><P>The answer depends on the text format of WeeksDate and WeekMonth.</P><P>Can you post some example data?</P></BODY></HTML> Wed, 28 Jan 2015 08:08:53 GMT https://community.qlik.com/t5/QlikView/Converting-text-field-to-number/m-p/778526#M1032367 Colin-Albert 2015-01-28T08:08:53Z Re: Converting text field to number https://community.qlik.com/t5/QlikView/Converting-text-field-to-number/m-p/778527#M1032368 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Use dual function, let the second parameter be a number so that u can sort on number. Like a rowno() for example</P><P></P><P>HTH</P></BODY></HTML> Wed, 28 Jan 2015 08:18:00 GMT https://community.qlik.com/t5/QlikView/Converting-text-field-to-number/m-p/778527#M1032368 Anonymous 2015-01-28T08:18:00Z Re: Converting text field to number https://community.qlik.com/t5/QlikView/Converting-text-field-to-number/m-p/778528#M1032369 <HTML><HEAD></HEAD><BODY><P>WeekDates contains dates from the start of the wee to the end e.g 01-07 then months contains the month of the current selected week</P><P></P><P>Listbox will look like this</P><P>02-08 Mar</P><P>05-11 Jan</P><P>19-25 Jan...etc</P><P></P><P>I want to sot the list box to have months in a cronological order</P></BODY></HTML> Wed, 28 Jan 2015 08:25:28 GMT https://community.qlik.com/t5/QlikView/Converting-text-field-to-number/m-p/778528#M1032369 2015-01-28T08:25:28Z