Sorting Data and Time

[sohb2015]

Hello All,

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.

Can anyone suggest something that will sort the date and time properly.

Thanks

[rubenmarin1 · Accepted solution]

Hi Sohini, can you try using both in sort expression?:

=DateField + TimeField

[sunny_talwar]

I think it would be even better if the Timestamp is created like this:

TimeStamp(DateField + TimeField)

QlikView will read it as a number and hence will sort is correctly

[sohb2015]

Thanks Ruben. It worked.

Thank you Guys.