Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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.