
Not applicable
2011-05-29
12:05 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
5,175 Views
1 Solution
Accepted Solutions


Master II
2011-05-31
05:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
396 Views
2 Replies


Master II
2011-05-31
05:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Have you had a look into the BEFORE-function?
Peter
397 Views

Not applicable
2011-05-31
05:12 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you! I looked up this function, and it worked for my pivot table!
396 Views
