Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-02-06 04:11 AM

Quarter on Quarter % Change Pivot Table

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.

What is the expression formula for it? Appreciate the help!

   

YearQtrApartmentCondominium
2014-Q418,51914,102
2015-Q114,67213,851
2015-Q215,08613,823
2015-Q312,20813,568
2015-Q414,51813,808
2016-Q116,08413,510
2016-Q214,71815,097
2016-Q314,62714,396
2016-Q414,68814,199
2017-Q115,79514,401
2017-Q216,15214,714
2017-Q315,83414,947
2017-Q416,36515,783
305 Views
0 Likes
0 Replies