How to correct data values on load?

[#1]

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!

[udaya_kumar]

Hi Jason,

PFA the qvw file which shows your required functionality.