How do I make a table that automatically shows the previous day's values or a specific day's values?

[Anonymous]

I'm trying to create daily snapshots of the values of various projects, as they change daily. Currently, the database I work with only stores monthly snapshots. I need the ability to see the amount that the values change from day to day.

I currently use a table with a row for each project and a column with their values for each month as well as their current values. There are too many projects to manually copy the values from the current day into a new column to compare them to the next day's values.

How do I make a column in the table that automatically shows the previous day's values? Is there a way to pull the project values for a specific day without having daily snapshots stored in the database?

This is the current script for the project value (LE):

Sum(

     {<

     [Snapshot Type]={'LE'},

     Baseline=,

     Baseline_LE=,

     //AAKT-2772

     //[Direct Indirect Flag]={$(=$(vDirectIndirect))},

     [Default Type] = {$(=$(vCFType))},

     //--

     [Report Currency]={'$(=$(vSelectedCurrency))'},

     [SC Finance Filter]={1},

     [SC/Non-SC]={"$(=$(vSCNonSC))"}

     >}

     [Finance Amount]*$(vCurrencyConversionKPI)

)

[dplr-rn]

Just making sure i understand it correctly.

you have columns

A,B, MonthlySnapshot

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

[Anonymous]

Hi Dilip,

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.

[sujeetsingh]

I am confused a little. Do you want to say that you want to analyse data which do not exists in DB. You can manage it QVW and maintain a snapshot table there. Just follow the set analysis for time intelligence.

[dplr-rn]

Ok. The monthly snapshot is not overwritten in qlik

Is there a date field you can use to identify the monthly snapshot value from previous day? Load date or something?