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

    How to correct data values on load?

    Jason Willcox

      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!

       

      screenshot.PNG