topic Re: Dimension Limit in QlikView

Dimension Limit

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying to use dimension limits, but it is only working on the "top" 5 but not the "bottom" 5. What could be a reason for this, and how can it be fixed?

Re: Dimension Limit

nico_ilog — Tue, 19 Apr 2016 09:49:35 GMT

How are you implementing the Limits?

Nico

Re: Dimension Limit

Chanty4u — Tue, 19 Apr 2016 09:50:03 GMT

u can try below

Top 5 & Bottom 5 Values

Bottom customers:

FirstSortedValue(Customer, Aggr(Sum(Sales),Customer),1)

FirstSortedValue(Customer, Aggr(Sum(Sales),Customer),2)

...

FirstSortedValue(Customer, Aggr(Sum(Sales),Customer),5)

Topcustomers:

FirstSortedValue(Customer, -Aggr(Sum(Sales),Customer),1)

FirstSortedValue(Customer, -Aggr(Sum(Sales),Customer),2)

...

FirstSortedValue(Customer, -Aggr(Sum(Sales),Customer),5)

Re: Dimension Limit

rubenmarin — Tue, 19 Apr 2016 09:54:17 GMT

Hi Robyn, maybe there are lower values with both expressions=0 and 'Supress Zero values' is checked?

Re: Dimension Limit

Tue, 19 Apr 2016 09:54:40 GMT

Hi Nico,

Re: Dimension Limit

Tue, 19 Apr 2016 09:58:36 GMT

Thank you! That worked.

Re: Dimension Limit

Tue, 19 Apr 2016 09:59:28 GMT

Ruben,

Thank you so much.

Suppress Zero Values was checked.

I unchecked it and now it works!

Re: Dimension Limit

nico_ilog — Wed, 20 Apr 2016 08:55:46 GMT

Hi Rob,

How can i be of assistance?