topic Re: How to sort DD-MM-YYYY field by earliest date order? in QlikView https://community.qlik.com/t5/QlikView/How-to-sort-DD-MM-YYYY-field-by-earliest-date-order/m-p/1149856#M891283 <HTML><HEAD></HEAD><BODY><P>Sorry forgot to say it's a straight table. Unfortunately I can't send a sample as the data is confidential.</P></BODY></HTML> Mon, 22 Aug 2016 15:02:05 GMT 2016-08-22T15:02:05Z How to sort DD-MM-YYYY field by earliest date order? https://community.qlik.com/t5/QlikView/How-to-sort-DD-MM-YYYY-field-by-earliest-date-order/m-p/1149853#M891280 <HTML><HEAD></HEAD><BODY><P>Rookie question: How would I sort the field below (image attached) by earliest date order and with null values first. The date format is 'DD-MM-YYYY'.</P><P></P><P>Edit: Straight Table.</P><P></P><P>TIA</P><P><IMG __jive_id="135176" alt="Screen Shot 2016-08-22 at 2.56.08 PM.png" class="jive-image image-1" src="/legacyfs/online/135176_Screen Shot 2016-08-22 at 2.56.08 PM.png" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-sort-DD-MM-YYYY-field-by-earliest-date-order/m-p/1149853#M891280 2020-11-25T16:16:04Z Re: How to sort DD-MM-YYYY field by earliest date order? https://community.qlik.com/t5/QlikView/How-to-sort-DD-MM-YYYY-field-by-earliest-date-order/m-p/1149854#M891281 <HTML><HEAD></HEAD><BODY><P>What object is this? Straight table or table box? Would you be able to share a sample to look at?</P></BODY></HTML> Mon, 22 Aug 2016 14:33:41 GMT https://community.qlik.com/t5/QlikView/How-to-sort-DD-MM-YYYY-field-by-earliest-date-order/m-p/1149854#M891281 sunny_talwar 2016-08-22T14:33:41Z Re: How to sort DD-MM-YYYY field by earliest date order? https://community.qlik.com/t5/QlikView/How-to-sort-DD-MM-YYYY-field-by-earliest-date-order/m-p/1149855#M891282 <HTML><HEAD></HEAD><BODY><P>If the field is really a date you could choose numeric within the sort-options.If not you will need to make at first a date from them by using something like: date(date#(DateField, 'DD/MM/YYYY'), 'DD/MM/YYYY')</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 22 Aug 2016 14:34:50 GMT https://community.qlik.com/t5/QlikView/How-to-sort-DD-MM-YYYY-field-by-earliest-date-order/m-p/1149855#M891282 marcus_sommer 2016-08-22T14:34:50Z Re: How to sort DD-MM-YYYY field by earliest date order? https://community.qlik.com/t5/QlikView/How-to-sort-DD-MM-YYYY-field-by-earliest-date-order/m-p/1149856#M891283 <HTML><HEAD></HEAD><BODY><P>Sorry forgot to say it's a straight table. Unfortunately I can't send a sample as the data is confidential.</P></BODY></HTML> Mon, 22 Aug 2016 15:02:05 GMT https://community.qlik.com/t5/QlikView/How-to-sort-DD-MM-YYYY-field-by-earliest-date-order/m-p/1149856#M891283 2016-08-22T15:02:05Z Re: How to sort DD-MM-YYYY field by earliest date order? https://community.qlik.com/t5/QlikView/How-to-sort-DD-MM-YYYY-field-by-earliest-date-order/m-p/1149857#M891284 <HTML><HEAD></HEAD><BODY><P>Super easy. I thought I'd already tried sorting it via the UI. However, the null values appear on the bottom no matter what order the field is sorted by. </P><P></P><P>Thanks for your time.</P></BODY></HTML> Mon, 22 Aug 2016 15:19:29 GMT https://community.qlik.com/t5/QlikView/How-to-sort-DD-MM-YYYY-field-by-earliest-date-order/m-p/1149857#M891284 2016-08-22T15:19:29Z