Sorting options in Sankey Chart

[Sgreen83]

Hi, I am using the Sense Sankey extension in QlikSense, and I need to sort the order of the nodes by a given dimension. Unlike any other extensions or charts, there is no "Sorting" property to choose from on the right. Additionally, I can't figure out what logic it uses to sort in the first place. The nodes are not in Alphabetical or Numerical order, and they are not in order of the size of the measure used. Does anyone know how to sort the nodes in these charts, or have any ideas for a workaround? Thanks!

[JordyWegman · Accepted solution]

Hi,

This is indeed not possible. What you can do is download the Vizlib Sankey Chart. This gives the possibility to sort on what you want.

Jordy

Climber

[Sgreen83]

Thank you!

[Ashinair]

Hi,

You can use the duel function in the  dimension and it will get you the option to sort  

e.g.

=if(GAME='Cricket ',Dual(GAME,2),

if(GAME='Tennis' ,Dual(GAME,6),

if(GAME='Swimming' ,Dual(GAME,1),

if(GAME='Boxing' ,Dual(GAME,7),

if(GAME='Cycling' ,Dual(GAME,3),

if(GAME='HighJump' ,Dual(GAME,4),

if(GAME='Fencing', Dual(GAME,8),

if(GAME='Acting', Dual(GAME,5),

'Check'))))))))

Hope it helps