8 Replies Latest reply: Jul 9, 2018 3:13 AM by mazda miata 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:


      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?