topic Quarter on Quarter % Change Pivot Table in QlikView

topic Quarter on Quarter % Change Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Quarter-on-Quarter-Change-Pivot-Table/m-p/55502#M790463 <HTML><HEAD></HEAD><BODY><P>Hi, I have the following data and I would like to create a pivot table to show the q-o-q percentage change for each item.</P><P></P><P>What is the expression formula for it? Appreciate the help! </P><P>    </P><TABLE border="0" cellpadding="0" cellspacing="0" width="229"><TBODY><TR><TD class="xl65" height="17" width="98">YearQtr</TD><TD class="xl66" style="border-left: none;" width="57">Apartment</TD><TD class="xl66" style="border-left: none;" width="74">Condominium</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2014-Q4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">18,519</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14,102</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2015-Q1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14,672</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">13,851</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2015-Q2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15,086</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">13,823</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2015-Q3</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">12,208</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">13,568</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2015-Q4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14,518</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">13,808</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2016-Q1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">16,084</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">13,510</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2016-Q2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14,718</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15,097</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2016-Q3</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14,627</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14,396</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2016-Q4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14,688</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14,199</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2017-Q1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15,795</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14,401</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2017-Q2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">16,152</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14,714</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2017-Q3</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15,834</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14,947</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2017-Q4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">16,365</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15,783</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Quarter on Quarter % Change Pivot Table https://community.qlik.com/t5/QlikView/Quarter-on-Quarter-Change-Pivot-Table/m-p/55502#M790463 <HTML><HEAD></HEAD><BODY><P>Hi, I have the following data and I would like to create a pivot table to show the q-o-q percentage change for each item.</P><P></P><P>What is the expression formula for it? Appreciate the help! </P><P>    </P><TABLE border="0" cellpadding="0" cellspacing="0" width="229"><TBODY><TR><TD class="xl65" height="17" width="98">YearQtr</TD><TD class="xl66" style="border-left: none;" width="57">Apartment</TD><TD class="xl66" style="border-left: none;" width="74">Condominium</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2014-Q4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">18,519</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14,102</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2015-Q1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14,672</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">13,851</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2015-Q2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15,086</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">13,823</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2015-Q3</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">12,208</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">13,568</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2015-Q4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14,518</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">13,808</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2016-Q1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">16,084</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">13,510</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2016-Q2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14,718</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15,097</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2016-Q3</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14,627</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14,396</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2016-Q4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14,688</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14,199</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2017-Q1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15,795</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14,401</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2017-Q2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">16,152</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14,714</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2017-Q3</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15,834</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14,947</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">2017-Q4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">16,365</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15,783</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Quarter-on-Quarter-Change-Pivot-Table/m-p/55502#M790463 Anonymous 2020-11-25T16:16:04Z