topic Re: Syntax Calculation in QlikView https://community.qlik.com/t5/QlikView/Syntax-Calculation/m-p/491481#M183671 <HTML><HEAD></HEAD><BODY><P>''Trick' way</P><P>Use WeekNo as an expression, not a dimension</P></BODY></HTML> Sun, 29 Sep 2013 21:58:28 GMT Clever_Anjos 2013-09-29T21:58:28Z Syntax Calculation https://community.qlik.com/t5/QlikView/Syntax-Calculation/m-p/491480#M183670 <HTML><HEAD></HEAD><BODY><P>hi i have the following problem</P><P></P><P>using a dimension table pivot i am calculating stock level available.</P><P></P><P>i use the following Expression.</P><P></P><P>[Lagersaldo]</P><P>-</P><P></P><P>RangeSum(Above(sum(Order),0, rowno()))</P><P>+ </P><P>RangeSum(Above(SUM(Purchased),0, rowno()))</P><P></P><P></P><P>however when i add another dimension to the table and expand the expression fails to act in the way intended.</P><P></P><P>any advice. please see attached document.</P></BODY></HTML> Sat, 28 Sep 2013 20:22:39 GMT https://community.qlik.com/t5/QlikView/Syntax-Calculation/m-p/491480#M183670 2013-09-28T20:22:39Z Re: Syntax Calculation https://community.qlik.com/t5/QlikView/Syntax-Calculation/m-p/491481#M183671 <HTML><HEAD></HEAD><BODY><P>''Trick' way</P><P>Use WeekNo as an expression, not a dimension</P></BODY></HTML> Sun, 29 Sep 2013 21:58:28 GMT https://community.qlik.com/t5/QlikView/Syntax-Calculation/m-p/491481#M183671 Clever_Anjos 2013-09-29T21:58:28Z Re: Syntax Calculation https://community.qlik.com/t5/QlikView/Syntax-Calculation/m-p/491482#M183672 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>You may need to add total to the Above statements, eg</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">RangeSum(Above(TOTAL sum(Order),0, rowno()))</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Jonathan<BR /></SPAN></P></BODY></HTML> Mon, 30 Sep 2013 08:43:42 GMT https://community.qlik.com/t5/QlikView/Syntax-Calculation/m-p/491482#M183672 jonathandienst 2013-09-30T08:43:42Z