1 Reply Latest reply: Feb 7, 2017 4:00 AM by Uday Kumar RSS

    How to correct data values on load?

      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!