We are loading from different Excel sheets each month, which means that we have 12 different files for a year. Some of the sheets includes historical data. Somehow the historical data changes from file to file, I know this is really crappy data quality, but it will take ages to sort this out. Is there anyway I can tell Qlik which file that is the newest one? Maybe the order by function can help us in some way?
Is there any date field in your data. as if there is a date field then we can apply the condition that where last reload date is less than the date(that date which lies in your data), then pick only that data.
I have to warn you, we have made a "strange" logic that enables us to load the different excel sheets.
Attached you can find a sample file containing the sheets that have historically data. I am using the below script to load the ibbymonthindex sheet. The "Month" is growing right on the excel sheet from month to month. "Opening_date" is not changing.