topic Re: sorting in QlikView

sorting

Wed, 05 Nov 2014 13:27:38 GMT

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

Re: sorting

Anonymous — Wed, 05 Nov 2014 13:47:37 GMT

Usman,

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

Marc.

Re: sorting

Gysbert_Wassenaar — Wed, 05 Nov 2014 13:48:43 GMT

Try using a calculated dimension:

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

and sort that dimension by Y-value

Re: sorting

marcus_sommer — Wed, 05 Nov 2014 13:51:18 GMT

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