Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

Top 10 above target

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?


1 Reply
Honored Contributor II

Re: Top 10 above target


Try like below for Top 10

1) Using Set Analysis in Expression

Dimension = Product


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

2) Using Calculated Dimension

Dimension = use cal.dimension


for bottom 10