topic dimenssions and pivot in QlikView https://community.qlik.com/t5/QlikView/dimenssions-and-pivot/m-p/220892#M73749 <HTML><HEAD></HEAD><BODY><P>Hello there,</P><P>can anybody tell me why</P><P>=sum (</P><BR /><BR /> <P>sum( Qty ) - before ( sum( Qty )))</P><P>doesnt work in dimenssions / pivot table?</P><P>How to change this?</P><P>thank you!</P><P>Marta</P></BODY></HTML> Wed, 21 Oct 2009 15:32:42 GMT 2009-10-21T15:32:42Z dimenssions and pivot https://community.qlik.com/t5/QlikView/dimenssions-and-pivot/m-p/220892#M73749 <HTML><HEAD></HEAD><BODY><P>Hello there,</P><P>can anybody tell me why</P><P>=sum (</P><BR /><BR /> <P>sum( Qty ) - before ( sum( Qty )))</P><P>doesnt work in dimenssions / pivot table?</P><P>How to change this?</P><P>thank you!</P><P>Marta</P></BODY></HTML> Wed, 21 Oct 2009 15:32:42 GMT https://community.qlik.com/t5/QlikView/dimenssions-and-pivot/m-p/220892#M73749 2009-10-21T15:32:42Z dimenssions and pivot https://community.qlik.com/t5/QlikView/dimenssions-and-pivot/m-p/220893#M73750 <HTML><HEAD></HEAD><BODY><P>Marta,<BR /><BR />Try this: Sum(Qty) - Before(Sum(Qty)), you can't have in the same expression: Sum(Sum()). Maybe: Sum(Aggr(Sum(), .... ))<BR /><BR />Gabriel</P></BODY></HTML> Wed, 21 Oct 2009 21:04:17 GMT https://community.qlik.com/t5/QlikView/dimenssions-and-pivot/m-p/220893#M73750 GabrielAraya 2009-10-21T21:04:17Z