Solved: Sorting with wildmatch - Qlik Community

Anonymous · ‎2017-07-20

Good day everybody,

I have a table with:

+ Type: POT, WD...

+ No: numeric value

I want to sort by with these conditions:

The first priority is "Type", the second is "No" and it should be in Ascending.

It worked well with Type = {POT, WD, FLT} but with Type = "*" then the "No" field was not in order (ascending or descending)

Could you please suggest the idea. Thanks in advance.

I attached the qvw file & screenshot here.

sunny_talwar · ‎2017-07-20

May be create a new field in the script like this

Sorting:

LOAD *,

WildMatch(Type ,'POT','FLT','WD','????????','R-*') * 1000000 + No as Sort;

load * Inline [

Type, No

Aug 2017, 42948

Jun 2016, 42948

Dec 2016, 42948

May 2017, 42948

And then sort for Max(Sort)

View solution in original post

sunny_talwar · ‎2017-07-20

May be create a new field in the script like this

Sorting:

LOAD *,

WildMatch(Type ,'POT','FLT','WD','????????','R-*') * 1000000 + No as Sort;

load * Inline [

Type, No

Aug 2017, 42948

Jun 2016, 42948

Dec 2016, 42948

May 2017, 42948

And then sort for Max(Sort)

Anil_Babu_Samineni · ‎2017-07-20

Looks like, This is not make sense to me. Because, You don't have common value for first dimension. Why you need this?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2017-07-20

Thank Sunny, it was a good solution, it is not correct 100% but I could work around with your idea.

Anonymous · ‎2017-07-20

Hello Anil, thanks for your feedback.

I need to sort by "Type" field firstly then by "No" field. After considering Sunny's solution I have this screenshot and it reach my expectation 90%.