topic Re: Calculating with expressions in pivot tables in QlikView https://community.qlik.com/t5/QlikView/Calculating-with-expressions-in-pivot-tables/m-p/743697#M1030635 <HTML><HEAD></HEAD><BODY><P>Did you try Using Valuelist() ?</P></BODY></HTML> Wed, 22 Apr 2015 15:52:59 GMT 2015-04-22T15:52:59Z Calculating with expressions in pivot tables https://community.qlik.com/t5/QlikView/Calculating-with-expressions-in-pivot-tables/m-p/743696#M1030634 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P></P><P>I have a pivot table that does some basic calculations using a few expressions. What I am calculating is usually just the sum in each case and I show the subtotals. One of my dimensions is year and the purpose of the table is to compare year on year. What I want to do is to show the percentage change between years for each of the expressions (e.g. like a subtotal calculation in each column of the table) - does anyone know how I might do it? </P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Dept</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Year</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Total</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Status 1</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Status 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Status 3</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Status 4</STRONG></TH></TR><TR><TD colspan="1"></TD><TD colspan="1"></TD><TD colspan="1">16809</TD><TD colspan="1">9204</TD><TD colspan="1">1210</TD><TD colspan="1">80</TD><TD colspan="1">225</TD></TR><TR><TD style="padding: 2px;">Dept 1</TD><TD style="padding: 2px;">201516</TD><TD style="padding: 2px;">6223</TD><TD style="padding: 2px;">3378</TD><TD style="padding: 2px;">556</TD><TD style="padding: 2px;">32</TD><TD style="padding: 2px;">82</TD></TR><TR><TD style="padding: 2px;">Dept 1</TD><TD style="padding: 2px;">201415</TD><TD style="padding: 2px;">4736</TD><TD style="padding: 2px;">2419</TD><TD style="padding: 2px;">427</TD><TD style="padding: 2px;">37</TD><TD style="padding: 2px;">34</TD></TR><TR><TD>Dept 1</TD><TD>201314</TD><TD>3919</TD><TD>3800</TD><TD>186</TD><TD>35</TD><TD>35</TD></TR><TR><TD>Dept 2</TD><TD>201516</TD><TD>639</TD><TD>431</TD><TD>14</TD><TD>7</TD><TD>3</TD></TR><TR><TD>Dept 2</TD><TD>201415</TD><TD>919</TD><TD>980</TD><TD>21</TD><TD>2</TD><TD>1</TD></TR><TR><TD>Dept 2</TD><TD>201314</TD><TD>363</TD><TD>335</TD><TD>5</TD><TD>0</TD><TD>1</TD></TR></TBODY></TABLE><P></P><P>These are not the real figures....</P><P></P><P>I want to then be able to have for the total and for each status a row at the bottom that show % change between 201516 and 201415 and then another that shows percentage change between 201415 and 201314.</P><P></P><P>Does anyone have any suggestions? </P><P></P><P>Thanks</P><P></P><P>Alison</P></BODY></HTML> Wed, 18 Feb 2015 11:37:27 GMT https://community.qlik.com/t5/QlikView/Calculating-with-expressions-in-pivot-tables/m-p/743696#M1030634 alisonpwallis 2015-02-18T11:37:27Z Re: Calculating with expressions in pivot tables https://community.qlik.com/t5/QlikView/Calculating-with-expressions-in-pivot-tables/m-p/743697#M1030635 <HTML><HEAD></HEAD><BODY><P>Did you try Using Valuelist() ?</P></BODY></HTML> Wed, 22 Apr 2015 15:52:59 GMT https://community.qlik.com/t5/QlikView/Calculating-with-expressions-in-pivot-tables/m-p/743697#M1030635 2015-04-22T15:52:59Z