Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Sorting Problem

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()

7 Replies

Re: Sorting Problem

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

MVP
MVP

Re: Sorting Problem

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.

Not applicable

Re: Sorting Problem

is it work in sorting - exp?

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

MVP
MVP

Re: Sorting Problem

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.

Re: Sorting Problem

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

Not applicable

Re: Sorting Problem

I am using Qlik Sense.

Re: Sorting Problem

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

Community Browser