Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Have you had a look into the BEFORE-function?
Peter
Thank you! I looked up this function, and it worked for my pivot table!