Discussion Board for collaboration related to Creating Analytics for QlikView.
Hello, I'm new to QlikView and still trying to wrap my head around expressions.
I have the following problem to solve:
DimWeek , columnes:
I need to create a pivot chart with the following:
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?
Go to Solution.
Have you had a look into the BEFORE-function?
Thank you! I looked up this function, and it worked for my pivot table!