topic Re: Sorting Problem in QlikView

Sorting Problem

Mon, 04 Apr 2016 17:02:04 GMT

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 — Mon, 04 Apr 2016 17:13:17 GMT

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

swuehl — Mon, 04 Apr 2016 17:13:20 GMT

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.

Mon, 04 Apr 2016 17:25:35 GMT

is it work in sorting - exp?

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

swuehl — Mon, 04 Apr 2016 17:28:37 GMT

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 — Mon, 04 Apr 2016 17:31:13 GMT

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

Mon, 04 Apr 2016 17:40:02 GMT

I am using Qlik Sense.

sunny_talwar — Mon, 04 Apr 2016 17:41:35 GMT

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