Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Usman,
You can choose the sorting order only for your nine values, but Others always stand the last.
Marc.
Try using a calculated dimension:
=aggr(if(rank(sum(Percentage))<10,Company, 'Other'),Company)
and sort that dimension by Y-value
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