topic Re: Straight Table - Custom Sort Order in QlikView

Straight Table - Custom Sort Order

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

Hi All,

I have a sorting question in the straight table.

The data is like this in the straight table.

Name Owner

# of Dealing Authorities Keen

# of Compliants Keen

# of Breaks Lobato

# of Lates John

# of Calls Lobato

# of Incoming John

# of Outgoing Keen

I want to the table to be sorted as below

Name Owner

# of Dealing Authorities Keen

# of Outgoing Keen

# of Compliants Keen

# of Breaks Lobato

# of Calls Lobato

# of Incoming John

# of Lates John

Is the above possible? Is there an Custom Sort Order available on the Name column?

Thanks

Re: Straight Table - Custom Sort Order

sunny_talwar — Fri, 12 May 2017 18:47:35 GMT

Sure, you can use Match function

Match(Name, '# of Dealing Authorities', '# of Outgoing', '# of Compliants', '# of Breaks', '# of Calls', '# of Incoming', '# of Lates')

Re: Straight Table - Custom Sort Order

johnjustus — Fri, 12 May 2017 18:58:03 GMT

Thanks

I tried like this and did not work

Straight table Chart Properties -> Sort -> Columns -> Name -> Sort by Expression

If(Match(Name, '# of Dealing Authorities', '# of Outgoing', '# of Compliants', '# of Breaks', '# of Calls', '# of Incoming', '# of Lates'),Name)

Am I doing anything wrong?

Thanks

Re: Straight Table - Custom Sort Order

sunny_talwar — Fri, 12 May 2017 18:58:59 GMT

You just need this...

Match(Name, '# of Dealing Authorities', '# of Outgoing', '# of Compliants', '# of Breaks', '# of Calls', '# of Incoming', '# of Lates')

If is not needed

Re: Straight Table - Custom Sort Order

johnjustus — Fri, 12 May 2017 19:01:12 GMT

Yes, I realized that.

That's a good solution. Thanks

Re: Straight Table - Custom Sort Order

ziadm — Fri, 12 May 2017 19:06:39 GMT

Hi use Dual and Mapping

MapNameSort:

Mapping

LOAD * Inline [

Name,Order

# of Dealing Authorities,1

# of Outgoing,2

# of Compliants,3

# of Breaks,4

# of Calls,5

# of Incoming,6

# of Lates, 7

];

Table1:

load Dual(Name,ApplyMap('MapNameSort',Name)) as Name,

Owner;

load * Inline [

Name, Owner

# of Dealing Authorities, Keen

# of Compliants, Keen

# of Breaks, Lobato

# of Lates, John

# of Calls, Lobato

# of Incoming, John

# of Outgoing, Keen ];

after that sort by the Name in Ascending order in your chart or Table

Re: Straight Table - Custom Sort Order

Robertmccarthy2 — Tue, 09 Apr 2019 14:45:12 GMT

what if "is" is needed?

Re: Straight Table - Custom Sort Order

Robertmccarthy2 — Tue, 09 Apr 2019 15:03:10 GMT

What if "is" is needed?