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]

PFA

[devarasu07]

Hi,

just create measure like below,

count(Result)/count(TOTAL Result)

and sort tab add this expression and sort order change to desc.  like below,

[s10157754]

Dear Tresesco,

As I was using personal edition. If possible can guide me step by step on how you did this? Thanks for your help in advance!

Best Regards,

QianNing

[tresesco · Accepted solution]

1.Take Result as dimension.

2.Expression:  =count([Result]) / count( total Result)

3. Sort by: 'Y Value' - Descending

[satheshreddy]

Hi Zhang,

open chart Properties and got to sort and select Expression Sorting there you can paste your expression and select descending order and press apply and Press OK now you can see the requirement result.

Regards

Sathesh

[s10157754]

Dear Tresesco,

Thanks for your prompt reply. As I need to create different labelling for "Good", "Intermittent" & "Invalid". So I cannot use the solution that you have provided above. Is there a way to sort based on expression return value? Thanks so much for your help in advance!

Best Regards,

QianNing

[s10157754]

Dear Devarasu,

Thanks for your prompt reply. As I need to create different labelling for "Good", "Intermittent" & "Invalid". So I cannot use the solution that you have provided above. Is there a way to sort based on expression return value? Thanks so much for your help in advance!

Best Regards,

QianNing

[s10157754]

Dear Satti,

Thanks for your idea, but it looks like there is no way for me to paste my expressions under sort tab without a dimension.

Best Regards,

QianNing

[satheshreddy]

Hi Zhang,

you write using if condition like below

if(A='Good',1,if(A='M',2))

Regards

Sathish