topic Re: Sorting with wildmatch in QlikView

Sorting with wildmatch

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 20 Jul 2017 11:20:42 GMT

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 — Thu, 20 Jul 2017 11:31:37 GMT

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

Anonymous — Fri, 21 Jul 2017 02:55:18 GMT

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

Anonymous — Fri, 21 Jul 2017 03:10:27 GMT

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%.