topic Calculation in pivot table in QlikView https://community.qlik.com/t5/QlikView/Calculation-in-pivot-table/m-p/167870#M39268 <HTML><HEAD></HEAD><BODY><P>hi</P><P>please check the attached file and see if you issue is resolved</P><P>regards</P><P>peter</P></BODY></HTML> Fri, 27 Nov 2009 18:28:30 GMT 2009-11-27T18:28:30Z Calculation in pivot table https://community.qlik.com/t5/QlikView/Calculation-in-pivot-table/m-p/167867#M39265 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I'm back [:$]</P><P>I have a table (ResEvent) with :</P><UL><LI>ResEventId //Eventnumber</LI><LI>RelationId //Customer</LI><LI>GrossAmount //Price of the Event</LI><LI>TotalQuantity //Quantity Tickets Sold</LI><LI>BookYear //Year</LI></UL><P>That gives me :</P><P>ResEventId RelationId GrossAmount TotalQuantity BookYear</P><P>1 15 1800 90 2008</P><P>2 15 300 15 2008</P><P>3 15 2400 120 2009</P><P></P><P>What do I want to see ?</P><P>RelationId Quantity GrossAmount</P><P>2008 2009 Difference 2008 2009 Difference</P><P>15 105 120 x % 2100 2400 x %</P><P></P><P>I managed to create the table (pivot) BUT without the difference (the difference should be calculated, I can do it on paper (and excel and so on), but not in my QV-application.</P><P></P><P>Jochen</P></BODY></HTML> Fri, 27 Nov 2009 15:42:53 GMT https://community.qlik.com/t5/QlikView/Calculation-in-pivot-table/m-p/167867#M39265 2009-11-27T15:42:53Z Calculation in pivot table https://community.qlik.com/t5/QlikView/Calculation-in-pivot-table/m-p/167868#M39266 <HTML><HEAD></HEAD><BODY><P>hi</P><P>can you attach your file this can be done in the pivot table itself through an expression, i can show u</P><P>regards</P><P>peter</P></BODY></HTML> Fri, 27 Nov 2009 17:50:29 GMT https://community.qlik.com/t5/QlikView/Calculation-in-pivot-table/m-p/167868#M39266 2009-11-27T17:50:29Z Calculation in pivot table https://community.qlik.com/t5/QlikView/Calculation-in-pivot-table/m-p/167869#M39267 <HTML><HEAD></HEAD><BODY><P>Here you are...</P><P></P><P>File attached</P></BODY></HTML> Fri, 27 Nov 2009 18:02:06 GMT https://community.qlik.com/t5/QlikView/Calculation-in-pivot-table/m-p/167869#M39267 2009-11-27T18:02:06Z Calculation in pivot table https://community.qlik.com/t5/QlikView/Calculation-in-pivot-table/m-p/167870#M39268 <HTML><HEAD></HEAD><BODY><P>hi</P><P>please check the attached file and see if you issue is resolved</P><P>regards</P><P>peter</P></BODY></HTML> Fri, 27 Nov 2009 18:28:30 GMT https://community.qlik.com/t5/QlikView/Calculation-in-pivot-table/m-p/167870#M39268 2009-11-27T18:28:30Z Calculation in pivot table https://community.qlik.com/t5/QlikView/Calculation-in-pivot-table/m-p/167871#M39269 <HTML><HEAD></HEAD><BODY><P>Please see attacehd for one solution. This solution uses the before function in the expression to calculate this.</P><P>There are other ways such a set analysis that also could be sued to solve this.</P><P>Regards,</P><P>Fredrik</P></BODY></HTML> Fri, 27 Nov 2009 18:29:45 GMT https://community.qlik.com/t5/QlikView/Calculation-in-pivot-table/m-p/167871#M39269 2009-11-27T18:29:45Z Calculation in pivot table https://community.qlik.com/t5/QlikView/Calculation-in-pivot-table/m-p/167872#M39270 <HTML><HEAD></HEAD><BODY><P>Such simple anwers !!</P><P>Why didn't I found it ?</P></BODY></HTML> Fri, 27 Nov 2009 19:07:19 GMT https://community.qlik.com/t5/QlikView/Calculation-in-pivot-table/m-p/167872#M39270 2009-11-27T19:07:19Z