
Re: QV 11 Dimension Limits with negative values
Thomas Lindackers Mar 22, 2013 7:14 AM (in response to ionut biliuti)use this dimension: =if(Sales>0,Partener)
It works as designed. If restriction condition is set to "Show only values that accumulate to xxx relative to the total", negative values are not included in the calculation of the total ("Restriction sum", that is the total that is used for evaluating the restriction for a particular row). The reason for this is the following:
Imagine the following case:
A
2
1
3
The sum for this field is 0, which is undefined when you do relative calculation. What is the 40% limit of the sum 0 in this case? And how many values should be displayed?
The way to handle these questions, that makes most sense is to discard the negative values before performing the restrictions. Doing so, The sum is 3 and the 40% limit is more intuitive (1.2). Thus the value 1 will be shown.
A good is advice is to avoid relative restrictions when there are negative values as this can lead to a behaviour that is difficult to forsee (even though it is well defined)

Re: QV 11 Dimension Limits with negative values
Nitesh Srivastava Mar 22, 2013 10:55 AM (in response to ionut biliuti)Hi Bili,
Find the attached QVW file... Hope it helps...
Best Regards,
Nitesh

test dimension limit.qvw 162.5 K
