# QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

## Calculate weekly change in revenue for each week

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!

Tags (2)
1 Solution

Accepted Solutions
Honored Contributor II

## Calculate weekly change in revenue for each week

Have you had a  look into the BEFORE-function?

Peter

2 Replies
Honored Contributor II

## Calculate weekly change in revenue for each week

Have you had a  look into the BEFORE-function?

Peter

Not applicable

## Calculate weekly change in revenue for each week

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