Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi Jason,
PFA the qvw file which shows your required functionality.