Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
sebastian_fager
New Contributor II

Save/store data inside qvd

Hi,

I have a problem to find/calculate the historic Stock Availability.

In the meantime i want to save/store the Stock Availability per day per product.

How do i do that?


I have:

Product     Warehouse     Stock Availability

So i need to extract the values everyday, give it todays date and store it inside the qvd?

Regards Sebastian

3 Replies
rohitk1609
Valued Contributor II

Re: Save/store data inside qvd

Hi Sebastian,

How much data you can extract in initial load , like for last year , I believe you may at least once extract some old data and then write a incremental script and add one column as "Today() as date" and saves it on daily basis if the use case is your data is available only for this day. or if you can extract data on week , month so it is also possible ,Its all about your use case , data availability and use case.

sebastian_fager
New Contributor II

Re: Save/store data inside qvd

Hi,

There is no historical data, so i need to save down snapshots for everyday.

Roughly how do I write a incremental script to run everyday?

rohitk1609
Valued Contributor II

Re: Save/store data inside qvd

Hi

Please have a look into it

https://m.youtube.com/watch?v=UkKTmnKSNQo