Select data the day before dimension date in set analysis
I need a formula that selects data from the day before the shown dimension date on the actual dimension date.
I made an example of what I need in the table below. I should mention that the formula i want to create in the end takes data from the same day + data from the previous day, so it is not possible to change the formula of the date in the dimension field. I have tried to explain this as simple as possible.
This formula shows only the result of the last date that is part of the table -1. So the last date is 7th of April, and Qlik would show the figure of 6th of April, which is 20.
These formulas gave me only the result of 1 date. But i have a table with the data as a dimension, and I need a formula that shows me results of the day before the dimension date on the actual dimension date.
Re: Select data the day before dimension date in set analysis
Thanks for everyone's input. What I want to achieve is possible with the above function. The only thing is i don't get the correct value when there is no data on a date. As you can see in the image below, column 1178 gives on 1/8/2018 a value of 42:43:00. However a part of this value should be the value on 1/7/2018. So 8 January takes the data of 6 January.