Top 10 above target

Wed, 25 Nov 2020 16:16:04 GMT

I'm trying to show the top ten in one chart and the bottom ten in another but for some reason the top ten shows minus amounts. I've tried using dimension limits to show only first 10 and show only values that are greater than 1 but both are showing -.

Any ideas how I can do this?

Re: Top 10 above target

devarasu07 — Fri, 23 Jun 2017 10:42:31 GMT

Hi,

Try like below for Top 10

1) Using Set Analysis in Expression

Dimension = Product

Expression

Sum({<Product = {"=aggr(Rank(Sum(Sales),4),Product)<=10"}>} Sales)

2) Using Calculated Dimension

Dimension = use cal.dimension

=aggr(if(Rank(sum(Sales),4)<=10,Rank(sum(Sales))),Product)

for bottom 10

=aggr(if(Rank(-sum(Sales),4)<=10,Rank(-sum(Sales))),Product)

Thanks,Deva

topic Top 10 above target in QlikView

Top 10 above target

Re: Top 10 above target