topic How to correct data values on load? in QlikView https://community.qlik.com/t5/QlikView/How-to-correct-data-values-on-load/m-p/1290337#M620876 <HTML><HEAD></HEAD><BODY><P>Hi&nbsp; Qlik Viewers</P><P></P><P>I have a daily data set where a value should ONLY change on a date which corresponds to SUNDAY.</P><P></P><P>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.&nbsp; It could be changing on a date which corresponds to a Monday, Tuesay, Wednesday etc.</P><P></P><P>When this error occurs in the data set I want to auto correct <SPAN style="text-decoration: underline;">during the load</SPAN> by moving the Value to the previous date which corresponds to a Sunday.</P><P></P><P>Below is a simplified view of my data.&nbsp; 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.</P><P></P><P>Does anyone have any ideas how thiscan be done?</P><P></P><P>Thanks in advance!</P><P></P><P><IMG alt="screenshot.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/151929_screenshot.PNG" style="width: 777px; height: 483px;" /></P></BODY></HTML> Fri, 03 Feb 2017 14:27:58 GMT 2017-02-03T14:27:58Z How to correct data values on load? https://community.qlik.com/t5/QlikView/How-to-correct-data-values-on-load/m-p/1290337#M620876 <HTML><HEAD></HEAD><BODY><P>Hi&nbsp; Qlik Viewers</P><P></P><P>I have a daily data set where a value should ONLY change on a date which corresponds to SUNDAY.</P><P></P><P>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.&nbsp; It could be changing on a date which corresponds to a Monday, Tuesay, Wednesday etc.</P><P></P><P>When this error occurs in the data set I want to auto correct <SPAN style="text-decoration: underline;">during the load</SPAN> by moving the Value to the previous date which corresponds to a Sunday.</P><P></P><P>Below is a simplified view of my data.&nbsp; 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.</P><P></P><P>Does anyone have any ideas how thiscan be done?</P><P></P><P>Thanks in advance!</P><P></P><P><IMG alt="screenshot.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/151929_screenshot.PNG" style="width: 777px; height: 483px;" /></P></BODY></HTML> Fri, 03 Feb 2017 14:27:58 GMT https://community.qlik.com/t5/QlikView/How-to-correct-data-values-on-load/m-p/1290337#M620876 2017-02-03T14:27:58Z Re: How to correct data values on load? https://community.qlik.com/t5/QlikView/How-to-correct-data-values-on-load/m-p/1290338#M620877 <HTML><HEAD></HEAD><BODY><P>Hi Jason,</P><P></P><P>PFA the qvw file which shows your required functionality.</P></BODY></HTML> Tue, 07 Feb 2017 09:00:02 GMT https://community.qlik.com/t5/QlikView/How-to-correct-data-values-on-load/m-p/1290338#M620877 udaya_kumar 2017-02-07T09:00:02Z