topic Expression issue in QlikView https://community.qlik.com/t5/QlikView/Expression-issue/m-p/279786#M1181502 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a pivot chart with two demensional layers (Territory and Sub-Territory). My expression is correct when I am looking at the sub-territory level. However, when I drill back to look at it on a territory level, the expression is not totaling rows...it is computing on a territory level with is essentially averaging the sub-terriotry values. Is there a way to make this expression sum rows when looking at the top most level?</P><P></P><P>Thanks,</P><P>Jeff</P></BODY></HTML> Mon, 16 Jan 2012 18:58:05 GMT 2012-01-16T18:58:05Z Expression issue https://community.qlik.com/t5/QlikView/Expression-issue/m-p/279786#M1181502 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a pivot chart with two demensional layers (Territory and Sub-Territory). My expression is correct when I am looking at the sub-territory level. However, when I drill back to look at it on a territory level, the expression is not totaling rows...it is computing on a territory level with is essentially averaging the sub-terriotry values. Is there a way to make this expression sum rows when looking at the top most level?</P><P></P><P>Thanks,</P><P>Jeff</P></BODY></HTML> Mon, 16 Jan 2012 18:58:05 GMT https://community.qlik.com/t5/QlikView/Expression-issue/m-p/279786#M1181502 2012-01-16T18:58:05Z