topic Re: Problem in Cal. Dimension in QlikView https://community.qlik.com/t5/QlikView/Problem-in-Cal-Dimension/m-p/454861#M565063 <HTML><HEAD></HEAD><BODY><P>using this function</P><P><STRONG>rangesum(above(sum(Sales)</STRONG></P></BODY></HTML> Thu, 20 Dec 2012 07:24:44 GMT 2012-12-20T07:24:44Z Problem in Cal. Dimension https://community.qlik.com/t5/QlikView/Problem-in-Cal-Dimension/m-p/454859#M565061 <HTML><HEAD></HEAD><BODY><P>Hi Guys </P><P></P><P>Why my following expression is not working ????</P><P></P><P>=<SPAN style="color: #0000ff;">ValueList</SPAN>(<STRONG><EM style="color: #808080;">$(If(aggr(Rank(Sum(Sales)),Product) &lt;= 5,Product))</EM>) </STRONG></P><P></P><P>If i am removing the $ sign still i am getting error. and if i am putting ' '&nbsp; then no error but QV is not evaluating the condition(If(aggr(Rank(Sum(Sales)),Product) &lt;= 5,Product)) rather considering it as a text.</P><P></P><P><STRONG>Please Help </STRONG></P></BODY></HTML> Thu, 20 Dec 2012 06:28:31 GMT https://community.qlik.com/t5/QlikView/Problem-in-Cal-Dimension/m-p/454859#M565061 2012-12-20T06:28:31Z Re: Problem in Cal. Dimension https://community.qlik.com/t5/QlikView/Problem-in-Cal-Dimension/m-p/454860#M565062 <HTML><HEAD></HEAD><BODY><P>try rangesum function replacing sum</P><P>might be helpful.</P></BODY></HTML> Thu, 20 Dec 2012 07:18:30 GMT https://community.qlik.com/t5/QlikView/Problem-in-Cal-Dimension/m-p/454860#M565062 er_mohit 2012-12-20T07:18:30Z Re: Problem in Cal. Dimension https://community.qlik.com/t5/QlikView/Problem-in-Cal-Dimension/m-p/454861#M565063 <HTML><HEAD></HEAD><BODY><P>using this function</P><P><STRONG>rangesum(above(sum(Sales)</STRONG></P></BODY></HTML> Thu, 20 Dec 2012 07:24:44 GMT https://community.qlik.com/t5/QlikView/Problem-in-Cal-Dimension/m-p/454861#M565063 2012-12-20T07:24:44Z Re: Problem in Cal. Dimension https://community.qlik.com/t5/QlikView/Problem-in-Cal-Dimension/m-p/454862#M565064 <HTML><HEAD></HEAD><BODY><P>NOT WORKING </P></BODY></HTML> Thu, 20 Dec 2012 08:14:52 GMT https://community.qlik.com/t5/QlikView/Problem-in-Cal-Dimension/m-p/454862#M565064 2012-12-20T08:14:52Z