topic Re: Is there a way to sort data for input box in QlikView https://community.qlik.com/t5/QlikView/Is-there-a-way-to-sort-data-for-input-box/m-p/976938#M961869 <HTML><HEAD></HEAD><BODY><P>As Far as i know theres no sort on input box, it just takes value(s) from the user to store that value in a variable.</P></BODY></HTML> Wed, 14 Oct 2015 15:33:58 GMT Qrishna 2015-10-14T15:33:58Z Is there a way to sort data for input box https://community.qlik.com/t5/QlikView/Is-there-a-way-to-sort-data-for-input-box/m-p/976935#M961863 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am using input box to select the dates, and I want to sort the dates in descending order. Can any one guide me?</P><P></P><P>Thanks in advance!</P><P></P><P>Cheers!</P></BODY></HTML> Wed, 14 Oct 2015 15:29:39 GMT https://community.qlik.com/t5/QlikView/Is-there-a-way-to-sort-data-for-input-box/m-p/976935#M961863 varunreddy 2015-10-14T15:29:39Z Re: Is there a way to sort data for input box https://community.qlik.com/t5/QlikView/Is-there-a-way-to-sort-data-for-input-box/m-p/976936#M961865 <HTML><HEAD></HEAD><BODY><P>What expression are you using in your input box?</P></BODY></HTML> Wed, 14 Oct 2015 15:31:44 GMT https://community.qlik.com/t5/QlikView/Is-there-a-way-to-sort-data-for-input-box/m-p/976936#M961865 sunny_talwar 2015-10-14T15:31:44Z Re: Is there a way to sort data for input box https://community.qlik.com/t5/QlikView/Is-there-a-way-to-sort-data-for-input-box/m-p/976937#M961867 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P>=</P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 8pt;">Concat</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Distinct</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[As of Date]</SPAN><SPAN style="font-size: 8pt;">), ',', </SPAN><SPAN style="color: #800000; font-size: 8pt;">[As of Date]</SPAN><SPAN style="font-size: 8pt;">) </SPAN></SPAN></P></BODY></HTML> Wed, 14 Oct 2015 15:32:50 GMT https://community.qlik.com/t5/QlikView/Is-there-a-way-to-sort-data-for-input-box/m-p/976937#M961867 varunreddy 2015-10-14T15:32:50Z Re: Is there a way to sort data for input box https://community.qlik.com/t5/QlikView/Is-there-a-way-to-sort-data-for-input-box/m-p/976938#M961869 <HTML><HEAD></HEAD><BODY><P>As Far as i know theres no sort on input box, it just takes value(s) from the user to store that value in a variable.</P></BODY></HTML> Wed, 14 Oct 2015 15:33:58 GMT https://community.qlik.com/t5/QlikView/Is-there-a-way-to-sort-data-for-input-box/m-p/976938#M961869 Qrishna 2015-10-14T15:33:58Z Re: Is there a way to sort data for input box https://community.qlik.com/t5/QlikView/Is-there-a-way-to-sort-data-for-input-box/m-p/976939#M961870 <HTML><HEAD></HEAD><BODY><P>Maybe just use a negative sort weight:</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 8pt; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 8pt; font-family: inherit; color: #0000ff;">Concat</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 8pt; font-family: inherit;">(</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 8pt; font-family: inherit; color: #0000ff;">Distinct</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 8pt; font-family: inherit;">(</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 8pt; font-family: inherit; color: #800000;">[As of Date]</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 8pt; font-family: inherit;">), ',', -</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 8pt; font-family: inherit; color: #800000;">[As of Date]</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 8pt; font-family: inherit;">)</SPAN></SPAN></P></BODY></HTML> Wed, 14 Oct 2015 15:34:16 GMT https://community.qlik.com/t5/QlikView/Is-there-a-way-to-sort-data-for-input-box/m-p/976939#M961870 swuehl 2015-10-14T15:34:16Z Re: Is there a way to sort data for input box https://community.qlik.com/t5/QlikView/Is-there-a-way-to-sort-data-for-input-box/m-p/976940#M961871 <HTML><HEAD></HEAD><BODY><P>Hi Swuehl,</P><P></P><P>Thank You for your time. Negative sort weight works!</P><P></P><P>Cheers!</P></BODY></HTML> Wed, 14 Oct 2015 15:38:18 GMT https://community.qlik.com/t5/QlikView/Is-there-a-way-to-sort-data-for-input-box/m-p/976940#M961871 varunreddy 2015-10-14T15:38:18Z