topic Agreement wise Amount in QlikView https://community.qlik.com/t5/QlikView/Agreement-wise-Amount/m-p/230483#M82303 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i am calculating amount based on agreementid.</P><P>but agrement id will not included in dimension.</P><P>dimensions are state,region</P><P>how to find amount agreement wise without taking agrrement id in dimension.</P><P></P></BODY></HTML> Tue, 04 May 2010 05:34:21 GMT SunilChauhan 2010-05-04T05:34:21Z Agreement wise Amount https://community.qlik.com/t5/QlikView/Agreement-wise-Amount/m-p/230483#M82303 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i am calculating amount based on agreementid.</P><P>but agrement id will not included in dimension.</P><P>dimensions are state,region</P><P>how to find amount agreement wise without taking agrrement id in dimension.</P><P></P></BODY></HTML> Tue, 04 May 2010 05:34:21 GMT https://community.qlik.com/t5/QlikView/Agreement-wise-Amount/m-p/230483#M82303 SunilChauhan 2010-05-04T05:34:21Z Agreement wise Amount https://community.qlik.com/t5/QlikView/Agreement-wise-Amount/m-p/230484#M82304 <HTML><HEAD></HEAD><BODY><P>hi tom,</P><P>probably you can use aggr function</P><P>aggr(sum(amount),agreement id)</P><P></P><P>but there might be better way of doing this</P><P></P><P></P><P>thanks</P><P></P></BODY></HTML> Tue, 04 May 2010 06:30:50 GMT https://community.qlik.com/t5/QlikView/Agreement-wise-Amount/m-p/230484#M82304 2010-05-04T06:30:50Z Agreement wise Amount https://community.qlik.com/t5/QlikView/Agreement-wise-Amount/m-p/230485#M82305 <HTML><HEAD></HEAD><BODY><H1 class="CommonTitle">hi tauqueer,</H1><P class="CommonTitle">actually i am taking</P><P class="CommonTitle">aggr(sum(pnrcomdebtor)+sum(booksize),agreementid)</P><P class="CommonTitle">its showing blank</P><P class="CommonTitle">is there another way to do this</P></BODY></HTML> Tue, 04 May 2010 08:51:55 GMT https://community.qlik.com/t5/QlikView/Agreement-wise-Amount/m-p/230485#M82305 SunilChauhan 2010-05-04T08:51:55Z