Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try sorting on concatenated field like:
=Match(Factory&Process,'AQC','AProduce','AOutput','BProduce','BQC','BOutput','CQC','COutput','CProduce')
Hi Tresesco, I just tried but it didn't work on my side.
Could you share your sample app?
Please see attached. Thanks
Used dual(). PFA
It works. much appreciated!