13 Replies Latest reply: May 29, 2013 1:52 PM by Crystle Stamper RSS

    Decreasing Goal Line

    Crystle Stamper

      I have a set of data that I would like to create a decreasing goal line for. It is set up by weekly amounts.

       

      I would like to have it start with a value such as 1.7 and then decrease it by 9.8% for each week.

       

      My formula in excel was simple. [1.7-(1.7*.0098)] in the first row and then in the next row below that, have it reference the cell above it's value and subratact it by 9.8%

      [REF - (REF * .0098) and copy that forumula down the excel document.

       

      However, I cannot seem to replicate this formula in Qlikview. I tried using the AGGR function with no success. Does anyone know of a way to complete this formula in Qlikview?

       

      Any help would be greatly appreciated.