topic Show Top 10 values in a Line Chart (Avoid 'Others'; No Dimension Limits: v10) in QlikView

Show Top 10 values in a Line Chart (Avoid 'Others'; No Dimension Limits: v10)

dmohanty — Sun, 08 Dec 2013 09:54:37 GMT

Hi All,

I have a scenario to restrict the values on X-Axis of a Line chart to Top 10 and ignore others. But I am getting one 11th record as 'Others' (summation of rest values). Also I can't use Dimension Limits to restrict as it's version 10.

For example, I have 20 Years as dimension and Total Sales as KPI.

So could any one help me out how to ignore the 'Others'?

Regards!!!

Re: Show Top 10 values in a Line Chart (Avoid 'Others'; No Dimension Limits: v10)

dmohanty — Mon, 09 Dec 2013 07:24:16 GMT

Hi All,

I got the result by implementing the below Expression:

Sum({<Year = {"=Rank(sum(Sales))<=10"}>}Sales)

Also, in the Sort options, only enable: Y-value as Descending.

Also, if anyone has any other ways to implement, they are welcome to post.

Regards!!