topic Re: Dimension Limits in QlikView

Dimension Limits

p_noindl — Thu, 17 Jul 2014 12:13:03 GMT

Hi,

Anyone knows how to solve this issue:

I need to show only the top 10 (or the worst 10) customers sales based on the second expression (2014) . My customer insists on showing the expressions in the shown order.

I have tried it with rank in the dimensions tab ("enable conditional"), but didn't succeed.

Many thanks for your assistance!

Peter

Re: Dimension Limits

alexandros17 — Thu, 17 Jul 2014 12:17:05 GMT

Like this?

Re: Dimension Limits

Thu, 17 Jul 2014 12:40:07 GMT

See the attached qvw...

I used IF(AGGR(RANK(SUM({<Year = {'2014'}>}Sales)), Customer) <= 10,Customer)

as the calculated dimension.

Re: Dimension Limits

p_noindl — Thu, 17 Jul 2014 12:47:06 GMT

This is not the right solution, because dimension limits only work with the first expression and that is 2013. Your solution takes now the top 10 in 2013. I cannot change the expressions order.

Rank could be the solution but I didn't succedd with the syntax.

Re: Dimension Limits

Thu, 17 Jul 2014 12:50:56 GMT

Did you see my attached qvw? The top 10 customers based on sales in 2014 are shown in the chart... is that not what you want?

Re: Dimension Limits

p_noindl — Thu, 17 Jul 2014 13:13:11 GMT

Sorry, my answer was related to alessandro saccone's answer - I try no to transfer your expression to my - much complicater - qvw-document and will come back soon. Do you see any solution with rank in the dimensions tab ("enable conditional") - would be more flexible in my special case? Many thanks!

Re: Dimension Limits

p_noindl — Thu, 17 Jul 2014 13:18:01 GMT

Hi Jacob,

my expressions are as follows:

Forecast Actual Year:

sum(if(KeyDate >= vDateSelectStart and KeyDate <= vDateSelect, INV_QTY * TO_QUANTITY_DE ))/vDaysSelected * 365

Previous Year:

sum(if(KeyDate >= yearstart(vDateSelectStart - 365) and KeyDate <= YearEnd(vDateSelectStart - 365), INV_QTY * TO_QUANTITY_DE ))

Therefore Year = 2014 is a problem in this case.

Re: Dimension Limits

Thu, 17 Jul 2014 13:33:55 GMT

IF(AGGR(RANK((sum(if(KeyDate >= vDateSelectStart and KeyDate <= vDateSelect, INV_QTY * TO_QUANTITY_DE ))/vDaysSelected * 365)), Customer) <= 10,Customer)

give it a shot

Re: Dimension Limits

p_noindl — Thu, 17 Jul 2014 13:45:17 GMT

many thanks, but I have tried this before - it works, but I am getting a value for the "others", which destroys my scaling of the axis

Re: Dimension Limits

p_noindl — Thu, 17 Jul 2014 13:55:32 GMT

have a look:

Re: Dimension Limits

Thu, 17 Jul 2014 14:39:14 GMT

Make sure to check "suppress when value is null" under the dimension tab...

Re: Dimension Limits

p_noindl — Thu, 17 Jul 2014 20:30:42 GMT

Many thanks, that works! You have an idea how to show the worst 10 performers?

Re: Dimension Limits

p_noindl — Fri, 18 Jul 2014 08:16:07 GMT

Hi, could solve all problems in the meantime, many thanks!

Re: Dimension Limits

Fri, 18 Jul 2014 12:06:16 GMT

Glad to hear it !