Diminsion Limits and filtering

[#1]

Another Day, Another Question.

I have a file with sales results for all products(cant share though), i want to see which 15 products performed the worst so I can decide which products we will have to "let go". I know that I can do this using the Dimension Limits, this gives me a general idea for the performance of the products from the beginning of time. I want to see the products for this year(2014). when I filter on 2014 I see only the results of the Top 15 and then filtered by 2014, so my result is 2 products, while i expect 15 products.

I tried solving this by using a filter in the Expression but this gives exactly the same problem, does someone know how i can best approach this?

Thanks for the help

[MK_QSL]

Difficult to answer without having dummy data in hand...

but you can use below expression instead of Calculated Dimension...

=sum({<Product= {“*=rank(-sum(Sales),4)<=15”}>}   Sales)

[#3]

Maybe rank in set analysis.

[nizamsha]

It will show the rank in reverse order so u can easily pick the worst performance

=rank( rank( sum(sales)))

[#5]

Sadly these answers give the same result. I will try to explain again.

I have a bar chart which displays the sales of the 15 worst products

i have a listbox with years, like: 2014; 2013; 2012

when i press 2014 it gives only 2 results instead of the 15 worst sales for 2014.

The behavior the chart must have is Filter expression on Year, then filter on performance.

[MK_QSL]

Share sample dummy data along with your chart pls

[#7 · Accepted solution]

I found the problem, something went wrong in the Load Script, i had to do some calculations in the script first, then store it into QVD, drop the table and reload the QVD. then it worked like a charm.