How to store the data of t-1 and t-2 day in QlikSense

[kavita25]

Hello Everyone,

I want to store the data in one .qvd of previous day and one .qvd of previous to previous day on today's day.

For e.g 

20-02-20: Store the data for 19-02-20. This is done

20-02-20 : The other qvd should store the data for 18-02-20. How to do it?

Regards,

Kavita

[tresesco]

You might have to just tweak a bit on the solution you did for t-1 day. Could you share how you did for t-1?

[kavita25]

Hello, 

The data reloads everyday at 8:00 a.m. Therefore the data present is of previous day.

I want to store the data of previous to previous day also.

To compare if any modification is done.

Regards,

Kavita

[kavita25]

Hello,

Can anyone help me with the requirement.

@tresesco 

Regards,

Kavita

[tresesco]

Hi Kavita,

I can give a try. Please help with a bit more details. Do you have an incremental load? Please try to share your code snippet that gives an idea about your date fields; load strategy you are following and other deciding factors if any. 

[kavita25]

Hello,

Thankyou for your response.

I am fetching the data through an API, wherein I am storing the data in QVD  at 8:00 am in the morning.

So, for today for an e.g. its 24th the data contains till 23rd. T-1 data

I want to store the data of 24th till 25th where my data would be T-2 and on 25th the fresh load at 8:00 am would be of 24th data.

Regards,

Kavita