topic Set analysis with nested function and greater than value in App Development https://community.qlik.com/t5/App-Development/Set-analysis-with-nested-function-and-greater-than-value/m-p/1421521#M33753 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have to find sum of price, where round(price,1) &gt;0 using set analysis. </P></BODY></HTML> Mon, 18 Dec 2017 13:22:10 GMT Anonymous 2017-12-18T13:22:10Z Set analysis with nested function and greater than value https://community.qlik.com/t5/App-Development/Set-analysis-with-nested-function-and-greater-than-value/m-p/1421521#M33753 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have to find sum of price, where round(price,1) &gt;0 using set analysis. </P></BODY></HTML> Mon, 18 Dec 2017 13:22:10 GMT https://community.qlik.com/t5/App-Development/Set-analysis-with-nested-function-and-greater-than-value/m-p/1421521#M33753 Anonymous 2017-12-18T13:22:10Z Re: Set analysis with nested function and greater than value https://community.qlik.com/t5/App-Development/Set-analysis-with-nested-function-and-greater-than-value/m-p/1421522#M33754 <HTML><HEAD></HEAD><BODY><P>What is the dimension where you are checking round(price, 1) &gt; 0? May be try this</P><P></P><P><STRONG>Sum({&lt;Dimension = {"=round(Sum(price), 1) &gt; 0"}&gt;} price)</STRONG></P><P></P><P>or this</P><P></P><P><STRONG>Sum(RangeMax(round(price, 1), 0))</STRONG></P></BODY></HTML> Mon, 18 Dec 2017 13:36:43 GMT https://community.qlik.com/t5/App-Development/Set-analysis-with-nested-function-and-greater-than-value/m-p/1421522#M33754 sunny_talwar 2017-12-18T13:36:43Z