topic Re: Sorting Class() time Interval in QlikView

Sorting Class() time Interval

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Sorting Class() time Interval

kkkumar82 — Thu, 17 Mar 2016 13:19:46 GMT

Hi,

I think you can use the autonumber() for the same expression and use it in the "Sort" tab.

Thanks

Kiran Kumar

Re: Sorting Class() time Interval

sunny_talwar — Thu, 17 Mar 2016 13:20:31 GMT

May be use a dual() function around your current dimension and then use it with a number to do a numeric sort

Re: Sorting Class() time Interval

kkkumar82 — Thu, 17 Mar 2016 13:21:13 GMT

Hi ,

This may help you.

https://www.youtube.com/watch?v=X6d6K-pFX_8

Thanks

Kiran Kumar

Re: Sorting Class() time Interval

Anonymous — Thu, 17 Mar 2016 13:22:56 GMT

Autonumber() is a script function not UI function

Re: Sorting Class() time Interval

Anonymous — Thu, 17 Mar 2016 13:25:51 GMT

tried with dual() but no success

Re: Sorting Class() time Interval

sunny_talwar — Thu, 17 Mar 2016 13:31:28 GMT

Do you have a sample you can share?

Re: Sorting Class() time Interval

marcus_sommer — Thu, 17 Mar 2016 13:44:52 GMT

This don't work?

=dual(

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'),

num(subfield(Class((T_SEG),(1/24/60)*$(VInput)),' ',1)))

- Marcus

Re: Sorting Class() time Interval

Anonymous — Thu, 17 Mar 2016 13:59:17 GMT

Nope!!

See the attachment..

If I try in like Properties -> Sort -> Text -> A-Z, it works but with some selection it does not work, so I thought to go for expression to sort...

Re: Sorting Class() time Interval

Anonymous — Thu, 17 Mar 2016 13:59:55 GMT

Shared.

Re: Sorting Class() time Interval

sunny_talwar — Thu, 17 Mar 2016 14:03:39 GMT

Seems to be working what Marcus provided

Change the sorting to Numeric: