topic Re: Sorting Data and Time in QlikView https://community.qlik.com/t5/QlikView/Sorting-Data-and-Time/m-p/1049029#M352429 <HTML><HEAD></HEAD><BODY><P>Thanks Ruben. It worked.</P><P></P><P>Thank you Guys.</P></BODY></HTML> Sat, 30 Apr 2016 07:38:56 GMT sohb2015 2016-04-30T07:38:56Z Sorting Data and Time https://community.qlik.com/t5/QlikView/Sorting-Data-and-Time/m-p/1049026#M352426 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I got a requirement of sorting date and time in a trend chart. The date and time are in different columns. So, I have created a calculated dimension. To sort the chart according to this calculated dimension, I put the date column name in the expression. It sorts the dates properly, however, times are not sorted properly. </P><P></P><P>Can anyone suggest something that will sort the date and time properly.</P><P></P><P>Thanks</P></BODY></HTML> Fri, 29 Apr 2016 15:30:08 GMT https://community.qlik.com/t5/QlikView/Sorting-Data-and-Time/m-p/1049026#M352426 sohb2015 2016-04-29T15:30:08Z Re: Sorting Data and Time https://community.qlik.com/t5/QlikView/Sorting-Data-and-Time/m-p/1049027#M352427 <HTML><HEAD></HEAD><BODY><P>Hi Sohini, can you try using both in sort expression?:</P><P>=DateField + TimeField</P></BODY></HTML> Fri, 29 Apr 2016 15:50:36 GMT https://community.qlik.com/t5/QlikView/Sorting-Data-and-Time/m-p/1049027#M352427 rubenmarin 2016-04-29T15:50:36Z Re: Sorting Data and Time https://community.qlik.com/t5/QlikView/Sorting-Data-and-Time/m-p/1049028#M352428 <HTML><HEAD></HEAD><BODY><P>I think it would be even better if the Timestamp is created like this:</P><P></P><P><STRONG>TimeStamp(DateField + TimeField)</STRONG></P><P></P><P>QlikView will read it as a number and hence will sort is correctly</P></BODY></HTML> Fri, 29 Apr 2016 16:01:34 GMT https://community.qlik.com/t5/QlikView/Sorting-Data-and-Time/m-p/1049028#M352428 sunny_talwar 2016-04-29T16:01:34Z Re: Sorting Data and Time https://community.qlik.com/t5/QlikView/Sorting-Data-and-Time/m-p/1049029#M352429 <HTML><HEAD></HEAD><BODY><P>Thanks Ruben. It worked.</P><P></P><P>Thank you Guys.</P></BODY></HTML> Sat, 30 Apr 2016 07:38:56 GMT https://community.qlik.com/t5/QlikView/Sorting-Data-and-Time/m-p/1049029#M352429 sohb2015 2016-04-30T07:38:56Z