7 Replies Latest reply: Dec 6, 2012 9:28 AM by Ksenia Babikhina RSS

    Any day vs 7 days ago data

      Hi all!

      I have the following data:

      Date and Value.

      In table I want to get the Value for any Day, but alsoValue for the 7 days ago:

      Date and Value.png

      I use the expression: sum( {$<Day=,Month =,Date = {"$(=date(Date-7))"}>}Value ) but it doesn't work correctly.

      In Qlickview like this:

      result.png

      For any date i must have 2 Values : Value for date and Value for date-7 ago but idon't know how to solve this problem without load two values in script. Can any help?