topic Daily Qvd's Generation in QlikView

Daily Qvd's Generation

maniram23 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

How to generate the Daily base Qvds. As well as monthly qvd.

Regards,

prashanth1712 — Fri, 05 Aug 2016 11:17:48 GMT

Hi,

Use store and load daily basis.. and for monthly May be u have to load the monthly data.

MayilVahanan — Fri, 05 Aug 2016 11:50:15 GMT

Try like this

Daily Qvd:

Let vFreezeTableName = 'Daily_'&Date(Today(),'MMDDYYYY');

$(vFreezeTableName):

LOAD * from yourdatasource;

//Store freeze data into qvd

STORE $(vFreezeTableName) into $(vFreezeTableName).qvd(qvd);

monthly qvd:

If Floor(MonthStart(Today())) = Floor(Today()) Then

Let vFreezeTableName = 'Monthly_'&Date(Today(),'MMDDYYYY');

$(vFreezeTableName):

Load * from

Yourdatasoure;

//Store freeze data into qvd

STORE $(vFreezeTableName) into $(vFreezeTableName).qvd(qvd);

ENDIF;