topic Diminsion Limits and filtering in QlikView

Diminsion Limits and filtering

Thu, 15 May 2014 10:46:17 GMT

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

Re: Diminsion Limits and filtering

MK_QSL — Thu, 15 May 2014 10:54:06 GMT

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)

Re: Diminsion Limits and filtering

Thu, 15 May 2014 10:56:00 GMT

Maybe rank in set analysis.

Re: Diminsion Limits and filtering

nizamsha — Thu, 15 May 2014 10:59:31 GMT

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

=rank( rank( sum(sales)))

Re: Diminsion Limits and filtering

Thu, 15 May 2014 11:34:00 GMT

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.

Re: Diminsion Limits and filtering

MK_QSL — Thu, 15 May 2014 11:42:58 GMT

Share sample dummy data along with your chart pls

Re: Diminsion Limits and filtering

Thu, 15 May 2014 12:38:51 GMT

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.