Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

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.

Community Browser