Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ndeeleysww
Contributor

Just how DO I sort by expression in Qlik Sense?

Hi all,

I've added some data to a pivot table, but of course it's never in the order  that's needed!

The rows are text, and I can't sort them alphabetically as that isn't what its required.

Assuming the Column is [Costheader] and has values of 'Sales', 'Gross Costs' and 'Labour', what expression can I use to order them in this fashion?

Any help gratefully received!

Thanks

Neil


1 Solution

Accepted Solutions

Re: Just how DO I sort by expression in Qlik Sense?

Hi Neil,

You'll need to drag up this column so it's the first in the sort tab, uncheck sort auto and check 'sort by expression' can use this expression:

Match([Costheader], 'Sales', 'Gross Costs' and 'Labour')

3 Replies

Re: Just how DO I sort by expression in Qlik Sense?

Hi Neil,

You'll need to drag up this column so it's the first in the sort tab, uncheck sort auto and check 'sort by expression' can use this expression:

Match([Costheader], 'Sales', 'Gross Costs' and 'Labour')

ndeeleysww
Contributor

Re: Just how DO I sort by expression in Qlik Sense?

Brilliant!  - thanks Ruben!

Not applicable

Re: Just how DO I sort by expression in Qlik Sense?

Helpful, thanks Ruben!

Community Browser