Qlik Community

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
prieper
Honored Contributor II

Calculate weekly change in revenue for each week

Have you had a  look into the BEFORE-function?

Peter

2 Replies
prieper
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!

Community Browser