Just making sure i understand it correctly.
you have columns
this monthly snapshot is being overwritten everyday.
when you reload the next day you want to retains todays value in some format. e.g.
A,B, MonthlySnapshot, PreviousDaySnapshot
is that right?
if it is i would save a qvd daily and on the next day you can append previous days value as a new column
step 1- reload from Database
step 2 - load qvd into a temp table , renaming MonthlySnapshot column as PreviousDaySnapshot
step 3 - join your table with temp table to add column PreviousDaySnapshot
step 4 - save as qvd
Thank you for your reply.
The monthly snapshot is not overwritten. The monthly snapshot works well, but I need a daily snapshot. Since the database does not have a daily snapshot, I have to figure out a new way. However, you seem to understand my question otherwise.
The data changes daily, besides the monthly snapshots. I'm looking to find a way to make daily snapshots.
When I tried to create a library for the qvd, I found that my company's Qlik team has blocked my access to messing with the libraries.
Do you have any coding ideas to suggest? Currently, I'm exporting the data to excel and sending out a comparison of the data daily, which is more manual than I would like. I was hoping for a time-based function that I was unaware of.