Sorting by Expression in Pivot Table

[chiayaochang]

Hi, 

I was hoping to use custom sort in Qlik Sense dependent on dimensions. 

Example data set:

LOAD * INLINE [
Factory,Process,Time,
A,QC,1.5
A,Produce,0.7
A,Output,2.1
B,QC,0.5
B,Produce,3.7
B,Output,1.1
C,QC,1.8
C,Produce,1.7
C,Output,2.2];  

I was able to use =Match(Process,'QC','Produce','Output') to sort but this order applies to all first layer "Factory". What I want to achieve is that

"Process" order for Factory A : 'QC','Produce','Output'

"Process" order for Factory B : 'Produce','QC','Output'

"Process" order for Factory C : 'QC','Output','Produce'

I tried 
=pick(match(Factory,'A','B','C'),Match(Process,'QC','Produce','Output'),Match(Process,'Produce','QC','Output'),Match(Process,'QC','Output','Produce')) but it doesn't work as expected.

[tresB]

Try sorting on concatenated field like:

=Match(Factory&Process,'AQC','AProduce','AOutput','BProduce','BQC','BOutput','CQC','COutput','CProduce')

[chiayaochang]

Hi Tresesco, I just tried but it didn't work on my side.

[tresB]

Could you share your sample app?

[chiayaochang]

Please see attached. Thanks

[tresB · Accepted solution]

Used dual(). PFA

[chiayaochang]

It works. much appreciated!