topic Re: Custom Sort Order in QlikView

Custom Sort Order

wonkymeister — Mon, 09 Mar 2015 11:01:41 GMT

morning,

struggling to engage brain today

i need to create a custom sort order for a dimension of text values.

Car

Bus

Plane

Boat

etc

any ideas? can DUALbe used in this scenario?

cheers.

Re: Custom Sort Order

anbu1984 — Mon, 09 Mar 2015 11:16:10 GMT

In expression of Sort tab, use below

Match(Dim,'Car','Bus','Plane','Boat')

Re: Custom Sort Order

stigchel — Mon, 09 Mar 2015 11:19:07 GMT

Good morning,

Yes it's monday 🙂 And yes you can use the dual function. In load script load a dual value of the dimension, I would first load a map of sort order values

TextSort:

mapping load * inline [Text,SortOrder

'Car',1

'Bus',2

];

And then load the Dimension as

Dual(YourDim,Applymap('TextSort',YourDim)

In the chart sort your dimension by numeric value.

Regards,

Piet Hein

Re: Custom Sort Order

jpenuliar — Mon, 09 Mar 2015 11:20:30 GMT

Hi WonkyMeister,

If you have a long list of items in your Dimension,

You can have a numeric Flag assigned to each unique item.

Applymap from a master list(excel,txt, or db table)

Re: Custom Sort Order

wonkymeister — Mon, 09 Mar 2015 11:35:13 GMT

many thanks - got Monday morning brain fog