Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sorting Class() time Interval

Hello Everyone,

How can I sort this expression, I have seen thread for Numeric value but did not find anything for Time Interval..

=time(subfield(Class((T_SEG),(1/24/60)*$(VInput)),' ',1),'hh:mm')

& ' to '

& time(subfield(Class((T_SEG),(1/24/60)*$(VInput)),' ',5),'hh:mm')

Please suggest

10 Replies
sunny_talwar

Seems to be working what Marcus provided

Capture.PNG

Change the sorting to Numeric:

Capture.PNG