topic Making a calculation based on cell values in a pivot table. in QlikView https://community.qlik.com/t5/QlikView/Making-a-calculation-based-on-cell-values-in-a-pivot-table/m-p/211876#M66033 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>Please find your solution here</P><P><A href="http://community.qlik.com/forums/t/27247.aspx">http://community.qlik.com/forums/t/27247.aspx</A></P><P>some nice posting some by John.</P><P>Regards,</P><P>Ravi</P></BODY></HTML> Fri, 03 Dec 2010 10:34:36 GMT 2010-12-03T10:34:36Z Making a calculation based on cell values in a pivot table. https://community.qlik.com/t5/QlikView/Making-a-calculation-based-on-cell-values-in-a-pivot-table/m-p/211873#M66030 <HTML><HEAD></HEAD><BODY><P></P><P>I am using a pivot table to show sales data and have displayed "Year" on the horizontal axis. I want to calculate the difference between the years. In Excel I would simply do something like "=A1-B1". Is it possible to do something like this in Qlik?</P><P></P></BODY></HTML> Fri, 03 Dec 2010 02:04:54 GMT https://community.qlik.com/t5/QlikView/Making-a-calculation-based-on-cell-values-in-a-pivot-table/m-p/211873#M66030 2010-12-03T02:04:54Z Making a calculation based on cell values in a pivot table. https://community.qlik.com/t5/QlikView/Making-a-calculation-based-on-cell-values-in-a-pivot-table/m-p/211874#M66031 <HTML><HEAD></HEAD><BODY><P>Hi <A href="http://community.qlik.com/members/chriso/default.aspx"><STRONG>Chris Philpot</STRONG></A> ,</P><P>You can try Before and After Function .</P><P>Regards,</P><P>Chakravarthy.</P></BODY></HTML> Fri, 03 Dec 2010 10:23:15 GMT https://community.qlik.com/t5/QlikView/Making-a-calculation-based-on-cell-values-in-a-pivot-table/m-p/211874#M66031 2010-12-03T10:23:15Z Making a calculation based on cell values in a pivot table. https://community.qlik.com/t5/QlikView/Making-a-calculation-based-on-cell-values-in-a-pivot-table/m-p/211875#M66032 <HTML><HEAD></HEAD><BODY><P>You can try use Set Analisys, there are many information on this forum.</P></BODY></HTML> Fri, 03 Dec 2010 10:30:45 GMT https://community.qlik.com/t5/QlikView/Making-a-calculation-based-on-cell-values-in-a-pivot-table/m-p/211875#M66032 2010-12-03T10:30:45Z Making a calculation based on cell values in a pivot table. https://community.qlik.com/t5/QlikView/Making-a-calculation-based-on-cell-values-in-a-pivot-table/m-p/211876#M66033 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>Please find your solution here</P><P><A href="http://community.qlik.com/forums/t/27247.aspx">http://community.qlik.com/forums/t/27247.aspx</A></P><P>some nice posting some by John.</P><P>Regards,</P><P>Ravi</P></BODY></HTML> Fri, 03 Dec 2010 10:34:36 GMT https://community.qlik.com/t5/QlikView/Making-a-calculation-based-on-cell-values-in-a-pivot-table/m-p/211876#M66033 2010-12-03T10:34:36Z