topic Re: Table Custom Sort in QlikView

Table Custom Sort

alec1982 — Thu, 10 Jan 2013 19:25:33 GMT

Hi Guys,

I have a table chart where the first dimenssion is fixed values and it is sorted text A->Z

Field1

Current Montn

Current Year

Next 5 Years

Next 10 Years

Next 30 Days

Next 60 Days

Next 90 Days

Next 120 Days

Is there anyway to do custom sort so the table will look like:

Field1

Current Month

Current Year

Next 30 Days

Next 60 Days

Next 90 Days

Next 120 Days

Next 5 Years

Next 10 Years

Thxs,

Alec

Re: Table Custom Sort

Anonymous — Thu, 10 Jan 2013 19:37:21 GMT

create a inline table like

load #inline

[

field you need to sort, sort order

Current Month,1

Current Year,2

Next 30 Days,3

Next 60 Days,4

Next 90 Days,5

Next 120 Days,6

Next 5 Years,7

Next 10 Years,8

];

and drop this inline table

hope this help

Re: Table Custom Sort

alec1982 — Thu, 10 Jan 2013 19:40:39 GMT

Hi,

May you please give me more details on where should I put this table. in the script? or on the sort tab expression?

Thxs,

Re: Table Custom Sort

Anonymous — Thu, 10 Jan 2013 19:41:35 GMT

in the script

Re: Table Custom Sort

alec1982 — Thu, 10 Jan 2013 19:47:14 GMT

Oh! I just wanted to say i cannot use it in the script.

Is there anyway to cstom sort in the chart?

Thxs for your help!

Alec

Re: Table Custom Sort

Anonymous — Thu, 10 Jan 2013 19:53:33 GMT

then use expression in the sort tab like

=match([field that need to be sorted],'Current Month','Current Year','Next 30 Days','Next 60 Days', etc)

Re: Table Custom Sort

alec1982 — Thu, 10 Jan 2013 19:55:03 GMT

Thxs for your help!