topic Re: Chart Display - Top 5 *and* only positive values? in QlikView https://community.qlik.com/t5/QlikView/Graph-Display-Top-5-and-only-positive-values/m-p/715405#M1052910 <HTML><HEAD></HEAD><BODY><P>Here you have an example</P><P></P><P>if you need only positive values use function fabs()</P></BODY></HTML> Tue, 28 Oct 2014 20:12:26 GMT ecolomer 2014-10-28T20:12:26Z Graph Display - Top 5 *and* only positive values? https://community.qlik.com/t5/QlikView/Graph-Display-Top-5-and-only-positive-values/m-p/715404#M1052909 <HTML><HEAD></HEAD><BODY><P>Hi all -</P><P></P><P>I have some graphs where I would only like to display positive values, and only show the top 5 values.&nbsp; I know you can do each of these individually in Dimension Limits, but how do you do both at once?&nbsp; I tried Set analysis for expressions, but couldn't figure out the syntax to only include values greater than 0.&nbsp; Thanks!</P></BODY></HTML> Tue, 28 Oct 2014 19:19:02 GMT https://community.qlik.com/t5/QlikView/Graph-Display-Top-5-and-only-positive-values/m-p/715404#M1052909 2014-10-28T19:19:02Z Re: Chart Display - Top 5 *and* only positive values? https://community.qlik.com/t5/QlikView/Graph-Display-Top-5-and-only-positive-values/m-p/715405#M1052910 <HTML><HEAD></HEAD><BODY><P>Here you have an example</P><P></P><P>if you need only positive values use function fabs()</P></BODY></HTML> Tue, 28 Oct 2014 20:12:26 GMT https://community.qlik.com/t5/QlikView/Graph-Display-Top-5-and-only-positive-values/m-p/715405#M1052910 ecolomer 2014-10-28T20:12:26Z Re: Chart Display - Top 5 *and* only positive values? https://community.qlik.com/t5/QlikView/Graph-Display-Top-5-and-only-positive-values/m-p/715406#M1052911 <HTML><HEAD></HEAD><BODY><P>My apologies - the title said chart, but I'm actually referencing a graph (sand chart).&nbsp; Because there are a lot of values to show, we want to limit the number of graphed segments to 5.&nbsp; Unfortunately, some of the data behind these segments is negative.&nbsp; From a data perspective, this is correct, and we do not want the absolute value of the function.&nbsp; We just don't want the negative values to be factored in to the sand chart because QlikView's graphing capabilities freak out and draw very weird shapes when there are negative values.</P></BODY></HTML> Tue, 28 Oct 2014 20:20:26 GMT https://community.qlik.com/t5/QlikView/Graph-Display-Top-5-and-only-positive-values/m-p/715406#M1052911 2014-10-28T20:20:26Z Re: Graph Display - Top 5 *and* only positive values? https://community.qlik.com/t5/QlikView/Graph-Display-Top-5-and-only-positive-values/m-p/715407#M1052912 <HTML><HEAD></HEAD><BODY><P>you can also select the number or values with limitation of values of expression sorting descending and limit to 5 max values </P><P>Is this a solution?</P></BODY></HTML> Tue, 28 Oct 2014 20:32:37 GMT https://community.qlik.com/t5/QlikView/Graph-Display-Top-5-and-only-positive-values/m-p/715407#M1052912 ecolomer 2014-10-28T20:32:37Z Re: Re: Graph Display - Top 5 *and* only positive values? https://community.qlik.com/t5/QlikView/Graph-Display-Top-5-and-only-positive-values/m-p/715408#M1052913 <HTML><HEAD></HEAD><BODY><P>See this example</P></BODY></HTML> Tue, 28 Oct 2014 20:34:20 GMT https://community.qlik.com/t5/QlikView/Graph-Display-Top-5-and-only-positive-values/m-p/715408#M1052913 ecolomer 2014-10-28T20:34:20Z Re: Re: Graph Display - Top 5 *and* only positive values? https://community.qlik.com/t5/QlikView/Graph-Display-Top-5-and-only-positive-values/m-p/715409#M1052914 <HTML><HEAD></HEAD><BODY><P>Enrique - the set analysis answer seems to have worked the best.&nbsp; Thank you!</P></BODY></HTML> Tue, 28 Oct 2014 20:49:23 GMT https://community.qlik.com/t5/QlikView/Graph-Display-Top-5-and-only-positive-values/m-p/715409#M1052914 2014-10-28T20:49:23Z Re: Graph Display - Top 5 *and* only positive values? https://community.qlik.com/t5/QlikView/Graph-Display-Top-5-and-only-positive-values/m-p/715410#M1052915 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/message/643624">Graph Display - Top 5 *and* only positive values?</A></P><P>we can use Rank() function ,get the Top 5 Values and&nbsp; we can use RangeMax() function (or) set analysis we can get only Positive value.</P><P>ex: load * Inline [</P><P>Country,City,Product,Salesperson,Sales</P><P>USA,xxxx,Clothes,Joe,54900</P><P>UK,yyyy,Drugs,rajah,45000</P><P>India,zzzz,Plastic,Maya,48900</P><P>Pak,eeee,cots,ram,78900</P><P>newgeland,rrrrr,woods,jhon,90000</P><P>apgan,llll,stell,boby,56000</P><P>westindians,ffff,beds,kumar,-43900];</P><P></P><P>In the above table i want top&nbsp; 5 sales persons</P><P>=if(aggr(rank(sum(Sales),Product,Salesperson)&lt;=4,Salesperson)</P><P>In Bar Chart,I want only display positive values</P><P>RangeMax(Sum(Sales),0)</P><P>or</P><P>sum({&lt;Country={"=Aggr(sum(Sales),Country)&gt;=0"}&gt;}Sales)</P></BODY></HTML> Wed, 29 Oct 2014 05:15:35 GMT https://community.qlik.com/t5/QlikView/Graph-Display-Top-5-and-only-positive-values/m-p/715410#M1052915 2014-10-29T05:15:35Z