topic Need help on Qvd transformation in QlikView

Need help on Qvd transformation

prasoon92 — Fri, 21 Dec 2018 21:58:04 GMT

I have a requirement where I need to create separate Qvd loader dashboard.
In my current scenario I am loading data into Qvd on a daily basis.

Suppose we need to add more applications on my dashboard and need data for new application for the old dates. How can I load data for a previous dates for new applications. Need something like start date and end date I give and application name to load data for previous dates

Re: Need help on Qvd transformation

dplr-rn — Fri, 21 Dec 2018 22:05:05 GMT

Why not save the qvds with date saved as part of the name?
QVDName_12-10-2018.qvd, QVDName_12-11-2018.qvd etc.
you can load the qvds in a for loop with start date and end date

Hope i understood correctly

Re: Need help on Qvd transformation

swapniltaz — Mon, 31 Dec 2018 05:54:58 GMT

Hi ,

One way of looking at this would be to keep on loading the incremental Data in your QVD .

AT New application level you can have from Date and to Date , So though Complete Data is present you will filter out only the Data between From and To Date .

This will solve your purpose and No need of maintaining seperate QVD for different application .

There are avrious post available on Forum that can help you with From and TO date Filters