sorting

[#1]

Hello Everbody,

I have a very simple question regarding Sorting. I have a pie chart and restricted the value to 9 plus others,so altogether it become 10

The sorting is possible except for other an example is mentioend below.

company name - percentage

abc                         25%

efc                         10%

AFA                         2%

ADFADF                    1%

ASDASDAS               1%

OTHERS               66%

But I want that in asecding or descending order.

others     66%

ACC          25%

EFC          10%

AFA              2%

Thanks in advance                   

[Anonymous]

Usman,

You can choose the sorting order only for your nine values, but Others always stand the last.

Marc.

[Gysbert_Wassenaar]

Try using a calculated dimension:

=aggr(if(rank(sum(Percentage))<10,Company, 'Other'),Company)

and sort that dimension by Y-value

[marcus_sommer]

I'm not abolutely sure if it will be possible with the inbuild automatic but I think you will need a calculated dimension which all dimension-values which have a rank greater then 9 will be concluded into 'others' - see here for examples:

http://community.qlik.com/blogs/qlikviewdesignblog/2014/04/08/calculated-dimensions

Top 10 Rank and Dimension Limits?

- Marcus