I need to build a movement report which involves movement of data from the same table.
The keys used are going to be company, branch, clientnumber and claimnumber. I'll be comparing changes in estimates.
I want to take a snapshot of this table at the start of each month and store as a separate table that doesn't get altered throughout.
This snapshot table is then referenced back to the original table each day throughout the month and if the difference in estimates between the daily reloaded table and the monthly snapshot table aren't zero, then I can put an indicator against the original table to state there has been some movement.
Is there any way to take snapshot reloads of data within the Qlikview reload script and if so how can this be done?
Let me know if further information is needed.