2 Replies Latest reply: May 31, 2011 5:12 PM by yuliyacoro RSS

    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!