How to sort pie chart in descending order without any dimension?

[s10157754]

Dear Qlikview Experts,

I have came across a situation whereby I do not have any dimension but with multiple expressions in a pie chart. The problem that I have faced was that I am not able to sort the pie chart in descending order. So I was wondering is it possible for me to sort the pie chart based on expression return value? (Such as from biggest % to smallest %) but I have no idea on how to do this.

I had attached the sample Qlikview File for your reference. Any other alternative ways to achieve the same outcome will be greatly appreciated as well! Thanks for your help in advanced!

Best Regards

QianNing

[tresesco]

You can still label it as you want using calculated dimension, like:

=Pick(Match(Result, 'Invalid', 'Intermittent', 'Good') , 'Something1', 'Tom', 'Harry')

[s10157754]

Dear Tresesco,

Thanks a ton for your help! Your solution works like a charm! Appreciated so much for your kind effort and have a nice day!

Best Regards

QianNing