Hello,
New to QlikView here and really sorry for asking such a basic question but could someone please explain how to calculate a percentage change in a straight table?
Say I have a straight table that has 2 columns currently, Period and Value and looks like this:
| Period | Value |
| Jan-15 | 100 |
| Feb-15 | 93 |
| Mar-15 | 88 |
| Apr-15 | 81 |
| May-15 | 76 |
| Jun-15 | 70 |
I would like to add a third column that simply calculates the percentage change
| Period | Value | % Change |
| Jan-15 | 100 | |
| Feb-15 | 93 | -7.00% |
| Mar-15 | 88 | -5.38% |
| Apr-15 | 81 | -7.95% |
| May-15 | 76 | -6.17% |
| Jun-15 | 70 | -7.89% |
My data set is obviously much larger and complex than this in actuality so I'd rather not calculate this in the load script, or do it in a pivot table. I've been trying to use a set analysis expression to no avail. Any help is appreciated!
