topic Re: Sorting Key in QlikView

Sorting Key

Tue, 19 Sep 2017 15:53:08 GMT

I want to change the order of my key by customizing it (i.e. Not ascending, descending by x or y value)

I have the following items in my one table ('Not Started', 'In Progress', 'In Review', 'Done', 'Onboarding Unsuccessful'). This is the order I would like them in.

How would I write an expression to sort them in this way?

Thank you!

Re: Sorting Key

sunny_talwar — Tue, 19 Sep 2017 15:55:44 GMT

May be a sort expression like this

Match(FieldName, 'Not Started', 'In Progress', 'In Review', 'Done', 'Onboarding Unsuccessful')

Re: Sorting Key

its_anandrjs — Tue, 19 Sep 2017 19:34:21 GMT

Maybe another one

Only( Match(FieldName, 'Not Started', 'In Progress', 'In Review', 'Done', 'Onboarding Unsuccessful') )

Only( {1} Match(FieldName, 'Not Started', 'In Progress', 'In Review', 'Done', 'Onboarding Unsuccessful') )

Re: Sorting Key

MarcoWedel — Tue, 19 Sep 2017 21:27:45 GMT

Hi,

another solution might be to preload this field e.g. using an inline load and check the "sort by ... load order" option in the sorting tab of your chart properties:

tabSortStatus:
LOAD * INLINE [
    Status
    Not Started
    In Progress
    In Review
    Done
    Onboarding Unsuccessful
];

table1:
LOAD RecNo() as ID,
     Pick(Ceil(Rand()*5), 'Not Started', 'In Progress', 'In Review', 'Done', 'Onboarding Unsuccessful') as Status
AutoGenerate 100;

hope this helps

regards

Marco