Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a data like below
i want asc order with the downdays ....
Where are you trying to sort this? Do you have a sample you can share?
I would suggest that you separate the two values into two fields, maybe like
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.
is it work in sorting - exp?
can you please share script, textbetween you are using, is it qv function?
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.
It is a QlikView and Qlik Sense question if that's what you are asking.
I am using Qlik Sense.
TextBetween will work in Qlik Sense as well. Where exactly are you trying to do this sorting? Can you share a sample?