topic Re: QV 11 Dimension Limits with negative values in QlikView https://community.qlik.com/t5/QlikView/QV-11-Dimension-Limits-with-negative-values/m-p/296636#M581041 <HTML><HEAD></HEAD><BODY><P>use this dimension: =if(Sales&gt;0,Partener)</P><P></P><P>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:</P><P>Imagine the following case: </P><P></P><P></P><P>A</P><P>2</P><P>1</P><P>-3</P><P></P><P></P><P>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?</P><P>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.</P><P></P><P></P><P>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)</P></BODY></HTML> Fri, 22 Mar 2013 11:14:56 GMT 2013-03-22T11:14:56Z QV 11 Dimension Limits with negative values https://community.qlik.com/t5/QlikView/QV-11-Dimension-Limits-with-negative-values/m-p/296635#M581040 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please take a look at the attached file.</P><P>I use the Dimension Limits to illustrate Pareto principle, by something go wrong.</P><P> Why are also displayed the negative values?</P><P><SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps">How can I avoid</SPAN> <SPAN class="hps">displaying</SPAN> <SPAN class="hps">negative</SPAN> <SPAN class="hps">values?</SPAN></SPAN></P><P></P><P>Thanks, </P><P>Have a nice day</P></BODY></HTML> Tue, 13 Dec 2011 14:33:48 GMT https://community.qlik.com/t5/QlikView/QV-11-Dimension-Limits-with-negative-values/m-p/296635#M581040 bilionut 2011-12-13T14:33:48Z Re: QV 11 Dimension Limits with negative values https://community.qlik.com/t5/QlikView/QV-11-Dimension-Limits-with-negative-values/m-p/296636#M581041 <HTML><HEAD></HEAD><BODY><P>use this dimension: =if(Sales&gt;0,Partener)</P><P></P><P>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:</P><P>Imagine the following case: </P><P></P><P></P><P>A</P><P>2</P><P>1</P><P>-3</P><P></P><P></P><P>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?</P><P>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.</P><P></P><P></P><P>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)</P></BODY></HTML> Fri, 22 Mar 2013 11:14:56 GMT https://community.qlik.com/t5/QlikView/QV-11-Dimension-Limits-with-negative-values/m-p/296636#M581041 2013-03-22T11:14:56Z Re: QV 11 Dimension Limits with negative values https://community.qlik.com/t5/QlikView/QV-11-Dimension-Limits-with-negative-values/m-p/296637#M581042 <HTML><HEAD></HEAD><BODY><P>Hi Bili,</P><P></P><P>Find the attached QVW file... Hope it helps...</P><P></P><P>Best Regards,</P><P>Nitesh</P></BODY></HTML> Fri, 22 Mar 2013 14:55:26 GMT https://community.qlik.com/t5/QlikView/QV-11-Dimension-Limits-with-negative-values/m-p/296637#M581042 2013-03-22T14:55:26Z