Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
ksharpes
Creator
Creator

Sort by Expression Pie Chart

Hello,

 

I am trying to arrange the Pie chart to show the legend in a particular order.

 

I have attempted to use the below formula in the sort by expression field but it does not work.

 

Match([Coverage Group],'Short','Medium','Long','Very Long','Dead Stock' and 'NYA')

sort.png

 

Also if the dimension used is a drill down dimension how would the expression look to cover each drill down?

1 Reply
Ivan_Bozov
Luminary
Luminary

Try this: Match([Coverage Group], 'Short', 'Medium', 'Long', 'Very Long', 'Dead Stock', 'NYA')
Also in the sorting options uncheck everything else and leave only Sort by expression.
vizmind.eu