Calculate weekly change in revenue for each week

[#1]

Hello, I'm new to QlikView and still trying to wrap my head around expressions.

I have the following problem to solve:

Two tables:

DimWeek , columnes:

WeekID,

WeekStartDay,

WeekEndDate,

WeekName

MyOrders, columnes:

OrderID,

WeekID,

Price

I need to create a pivot chart with the following:

Dimensions:

WeekName

Expressions:

Sum(Price)

Change in Sum(price)  comparing to previous week, so This Week's Sum(price) - Previous Week's Sum(Price)

So the question is: how do I calculate the change in Sum(price) for each week on the pivot chart?

Thank you!

[prieper · Accepted solution]

Have you had a  look into the BEFORE-function?

Peter

[#3]

Thank you! I looked up this function, and it worked for my pivot table!