Sorting Problem

[#1]

Hi,

I have a data like below

Date(DownDays)

01/04/2016()

01/14/2016(0.3)

01/14/2016(7.5)

01/21/2016(5.4)

i want asc order with the downdays ....

Result

01/14/2016(0.3)

01/21/2016(5.4)

01/14/2016(7.5)

01/14/2016()

[sunny_talwar]

Where are you trying to sort this? Do you have a sample you can share?

[swuehl]

I would suggest that you separate the two values into two fields, maybe like

LOAD

     Date#(Left(YourField, 10),'MM/DD/YYYY') as Date,

     Num#(Textbetween(YourField,'(',')')) as Down,

     ...

Then you should be able to sort by Down wherever you want.

[#4]

is it work in sorting - exp?

can you please share script, textbetween you are using, is it qv function?

[swuehl]

Well, I've just shared a script, kind of, haven't I?

And yes, Textbetween() is a QV function. Just hit F1 in the desktop client and search:

TextBetween(s , beforetext , aftertext [, n ])

Returns the text between the n:th occurrence of beforetext and the immediately following occurrence of aftertext within the string s.

[sunny_talwar]

It is a QlikView and Qlik Sense question if that's what you are asking.

[#7]

I am using Qlik Sense.

[sunny_talwar]

TextBetween will work in Qlik Sense as well. Where exactly are you trying to do this sorting? Can you share a sample?