Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
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

Labels (1)
10 Replies
sunny_talwar
MVP
MVP

Seems to be working what Marcus provided

Capture.PNG

Change the sorting to Numeric:

Capture.PNG