Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
kavita25
Partner
Partner

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

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

 

 

Labels (1)
5 Replies
tresesco
MVP
MVP

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
Partner
Partner
Author

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
Partner
Partner
Author

Hello,

Can anyone help me with the requirement.

@tresesco 

Regards,

Kavita

tresesco
MVP
MVP

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
Partner
Partner
Author

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