Discussion board where members can get started with Qlik Sense.
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!
Go to Solution.
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')
Brilliant! - thanks Ruben!
Helpful, thanks Ruben!