Hi Qlik Viewers
I have a daily data set where a value should ONLY change on a date which corresponds to SUNDAY.
For the most part this is what happens but I have some erroneous data where the date that the value changes does not correspond to a Sunday. It could be changing on a date which corresponds to a Monday, Tuesay, Wednesday etc.
When this error occurs in the data set I want to auto correct during the load by moving the Value to the previous date which corresponds to a Sunday.
Below is a simplified view of my data. If I am able to get the auto corrections to work as indicated in the example below then I should be able to correct my real data.
Does anyone have any ideas how thiscan be done?
Thanks in advance!