Date Value - the value a week ago

SilviyaK — Fri, 28 Jun 2024 14:19:03 GMT

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!

Re: Date Value - the value a week ago

rubenmarin — Sun, 30 Jun 2024 06:34:38 GMT

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-Straight-table/td-p/2466457

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

topic Re: Date Value - the value a week ago in App Development

Date Value - the value a week ago

Re: Date Value - the value a week ago