0 Replies Latest reply: Aug 7, 2014 7:18 AM by Eamonn Hannon RSS

    Use a previous weekly file if one doesn't exist for any week.

      Hi. I'm loading a weekly excel file to a qlikview app but I dont know how to load a copy of a previous week's file. If the file for a week is missing I want to use the previous week's file.  For example, if I have a file for week 1, week 2 and week 4 then I want to use the week 2 file (previous week) as the week 3 file also.  The contents of the file are target values.  It could contain up to 200 target values.

       

      I hope I have provided enough information and I look forward to hearing from someone.

       

      Thanks,

      Eamonn.