topic how to custom sort values in inputbox in QlikView https://community.qlik.com/t5/QlikView/how-to-custom-sort-values-in-inputbox/m-p/297764#M578548 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am using a input box in which i want to show timestamp from 12:00:00 AM to 11:00:00 PM. </P><P></P><P>Values should be shown in inputbox drop down like 12:00:00 AM</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1:00:00 AM</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2:00:00 AM</P><P>and so on upto 11:00:00 PM</P><P></P><P>but It is showing results Like given in below screenshot. Please help me to solve this issue. sample application is attached.</P><P><IMG alt="untitled.bmp" class="jive-image" src="https://community.qlik.com/legacyfs/online/11422_untitled.bmp" /></P></BODY></HTML> Mon, 20 Feb 2012 06:39:47 GMT sushil353 2012-02-20T06:39:47Z how to custom sort values in inputbox https://community.qlik.com/t5/QlikView/how-to-custom-sort-values-in-inputbox/m-p/297764#M578548 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am using a input box in which i want to show timestamp from 12:00:00 AM to 11:00:00 PM. </P><P></P><P>Values should be shown in inputbox drop down like 12:00:00 AM</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1:00:00 AM</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2:00:00 AM</P><P>and so on upto 11:00:00 PM</P><P></P><P>but It is showing results Like given in below screenshot. Please help me to solve this issue. sample application is attached.</P><P><IMG alt="untitled.bmp" class="jive-image" src="https://community.qlik.com/legacyfs/online/11422_untitled.bmp" /></P></BODY></HTML> Mon, 20 Feb 2012 06:39:47 GMT https://community.qlik.com/t5/QlikView/how-to-custom-sort-values-in-inputbox/m-p/297764#M578548 sushil353 2012-02-20T06:39:47Z how to custom sort values in inputbox https://community.qlik.com/t5/QlikView/how-to-custom-sort-values-in-inputbox/m-p/297765#M578549 <HTML><HEAD></HEAD><BODY><P> Try this as the custom expression</P><P></P><P>Concat(S_TIMESTAMP,',',sort)</P></BODY></HTML> Mon, 20 Feb 2012 07:01:28 GMT https://community.qlik.com/t5/QlikView/how-to-custom-sort-values-in-inputbox/m-p/297765#M578549 qliksus 2012-02-20T07:01:28Z