Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

dan-ketil
Contributor II

Show difference month by month

Hi

I have a table that I want to look like this

                    Area 1                           Area 2

               Value     Change                Value     Change

201201     10          0                         22          0

201202     18          8                         20          -2

201203      25         7                         24          4

..

My problem is the Change column. I nned it to show the cahnge form an period to the next

I found one forumla, but that adds the changes

=rangesum(above(column(1),1,(RowNo()-1)))//+ column(1)

How can I get the Change column to simply show the difference between from one period to another?

BR

Dan

1 Solution

Accepted Solutions
dan-ketil
Contributor II

Show difference month by month

I found a solution. Not sure it is the best one, but it solves my problem.

=rangesum(above(column(1),1,(RowNo()-1)))//+ column(1)

-rangesum(above(column(1),0,(RowNo()-1)))//+ column(1)

1 Reply
dan-ketil
Contributor II

Show difference month by month

I found a solution. Not sure it is the best one, but it solves my problem.

=rangesum(above(column(1),1,(RowNo()-1)))//+ column(1)

-rangesum(above(column(1),0,(RowNo()-1)))//+ column(1)

Community Browser