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.