topic How to sort values in input box in QlikView https://community.qlik.com/t5/QlikView/How-to-sort-values-in-input-box/m-p/143769#M22902 <HTML><HEAD></HEAD><BODY><P>I am populating an inputbox with the values of a field using concat function and now I want to sort the values.</P><P>Any help is appreciated.</P><P>Thanks.</P><P></P></BODY></HTML> Sat, 09 May 2009 03:09:40 GMT 2009-05-09T03:09:40Z How to sort values in input box https://community.qlik.com/t5/QlikView/How-to-sort-values-in-input-box/m-p/143769#M22902 <HTML><HEAD></HEAD><BODY><P>I am populating an inputbox with the values of a field using concat function and now I want to sort the values.</P><P>Any help is appreciated.</P><P>Thanks.</P><P></P></BODY></HTML> Sat, 09 May 2009 03:09:40 GMT https://community.qlik.com/t5/QlikView/How-to-sort-values-in-input-box/m-p/143769#M22902 2009-05-09T03:09:40Z How to sort values in input box https://community.qlik.com/t5/QlikView/How-to-sort-values-in-input-box/m-p/143770#M22903 <HTML><HEAD></HEAD><BODY><P>Raj,<BR />Can you provide some more details? Concat function can use optional paramater for sort order, but I can't tell if it's relevant to your question.</P></BODY></HTML> Sat, 09 May 2009 03:20:03 GMT https://community.qlik.com/t5/QlikView/How-to-sort-values-in-input-box/m-p/143770#M22903 Anonymous 2009-05-09T03:20:03Z How to sort values in input box https://community.qlik.com/t5/QlikView/How-to-sort-values-in-input-box/m-p/143771#M22904 <HTML><HEAD></HEAD><BODY><P>Michael,</P><P>I am populating 'YYYY-MM' values from year_month field in two inputboxes to be able to make comparison of facts between these two time periods. The problem is it a string field so it will not return numeric value when passed as a parameter for sort order in cancat function.</P><P>Is there any way to get around?</P><P>Thanks.</P></BODY></HTML> Sat, 09 May 2009 03:31:38 GMT https://community.qlik.com/t5/QlikView/How-to-sort-values-in-input-box/m-p/143771#M22904 2009-05-09T03:31:38Z How to sort values in input box https://community.qlik.com/t5/QlikView/How-to-sort-values-in-input-box/m-p/143772#M22905 <HTML><HEAD></HEAD><BODY><P>One possible way is to convert string to a date, like this before using for comarison:<BR />makedate(left(PeriodStart,4), right(PeriodStart,2))<BR />Another is to force user to enter in a date format (that ccould be YYYY-MM)</P></BODY></HTML> Sat, 09 May 2009 03:48:02 GMT https://community.qlik.com/t5/QlikView/How-to-sort-values-in-input-box/m-p/143772#M22905 Anonymous 2009-05-09T03:48:02Z How to sort values in input box https://community.qlik.com/t5/QlikView/How-to-sort-values-in-input-box/m-p/143773#M22906 <HTML><HEAD></HEAD><BODY><P>Looks like the most reliable way is combination of both. Take a look, notice the properties of the variables.<BR />I use expression that handles both YYYY-MM and YYYY-M situations.</P></BODY></HTML> Sat, 09 May 2009 07:19:10 GMT https://community.qlik.com/t5/QlikView/How-to-sort-values-in-input-box/m-p/143773#M22906 Anonymous 2009-05-09T07:19:10Z How to sort values in input box https://community.qlik.com/t5/QlikView/How-to-sort-values-in-input-box/m-p/143774#M22907 <HTML><HEAD></HEAD><BODY><P>Thanks for all your help Mike !!</P></BODY></HTML> Mon, 11 May 2009 20:33:40 GMT https://community.qlik.com/t5/QlikView/How-to-sort-values-in-input-box/m-p/143774#M22907 2009-05-11T20:33:40Z