Top and Low values in bar chart

[arulsettu]

Hi

i want to display top 10 and lowest 10 values based on sales in bar chart

SUM({<Customer = {"=Rank(-SUM(Sales),4)<=10"}>}Sales) i got this for lowest value.

how to show both values any help?

[tresesco]

Try:

SUM({<Customer = {"=Rank(-SUM(Sales),4)<=10  or Rank(SUM(Sales),4)<=10  "}>}Sales)

[arulsettu]

HI

it showing many values i need to display only 10 and how to identify the lowest values in this chart?

thank you

[tresesco]

You have to understand that set analysis doesn't work row-wise of a chart, it's a global filter. Therefore, you might have to try with Aggr(Rank(... combination for a chart; its depends on dimensions.

[arulsettu]

my dimension is customer

[arulsettu]

and it is possible to display like this

[tresesco]

Could you post a sample qvw? See: Preparing examples for Upload - Reduction and D... | Qlik Community

[arulsettu]

ok please wait i will post the app

[arulsettu]

here it is

[arulsettu]

any idea?