Date Value - the value a week ago

[SilviyaK]

Hi! 

I have the following chart:

This is basically value distributed by date. What I want is to create another bar chart where each bar will be the difference of the value between a specific date and 7 days before. For example, the 28/06/2024 needs to be showing me the value of 28/06/2024 minus 21/06/2024, then 27/06/2024 should be 27/06/2024 minus 20/06/2024, 26/06/2024 needs to be 26/06/2024 minus 19/06/2024 and so on...

This will be updated every day so a new date will be added on a daily basis. 

Thanks in advance!

[rubenmarin · Accepted solution]

Hi, I just answered a similar question on how to access diferent dates from a chart that uses a date field as dimensions, solutions can also be used in this case, but instead of adding or substracting a year, in can be done with 7 days: https://community.qlik.com/t5/Qlik-Reporting-Service/Calculated-Month-Year-sales-of-last-year-in-a-S...

The asof table option can be switched to directly access the data from 7 days ago.