topic SNAPSHOT MAKER OF QVD in QlikView

SNAPSHOT MAKER OF QVD

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

Hi Guys,

I have a table in which as on data is coming.. i want to see the data in backdate as well for that qvd data, for that cant i make snapshot of the data on daily basis?

Pls suggest

Regards

Abhay

Re: SNAPSHOT MAKER OF QVD

arulsettu — Wed, 06 Jul 2016 06:02:55 GMT

do you want to see the data in qvd?

Re: SNAPSHOT MAKER OF QVD

Wed, 06 Jul 2016 06:05:14 GMT

Hi,

Assuming you are using an incremental load it would be something like:

maxdate:

load max(date) as maxdate

from old.qvd;

let vMaxDate = peek('maxdate',-1,'maxdate');

Data:

load * from currentdatabase where date > vMaxDate;

Concatenate(Data)

load * from old.qvd;

Store Date into old.qvd;

Bit laborious but I haven't used incremental loads for a while.

Regards,

Pravesh

Re: SNAPSHOT MAKER OF QVD

abhaysingh — Wed, 06 Jul 2016 06:07:42 GMT

No i am not using any incremental load till now

Re: SNAPSHOT MAKER OF QVD

Wed, 06 Jul 2016 06:15:36 GMT

Should work either way, even without an incremental load strategy actually.

Re: SNAPSHOT MAKER OF QVD

tyagishaila — Wed, 06 Jul 2016 06:18:52 GMT

You can store qvd with variable name by this on daily basis you can Store QVD with different names.

Re: SNAPSHOT MAKER OF QVD

Wed, 06 Jul 2016 06:27:11 GMT

Yes, using a variable.

LET vMonthEnd = Date(FIELDVALUE('MONTH_END',1),'YYYYMMDD');

STORE LRA_Data into \\xx\yy\zz\LRA\abc_$(vMonthEndQVDName).qvd (qvd);

Re: SNAPSHOT MAKER OF QVD

Wed, 06 Jul 2016 06:47:59 GMT

Please mark a HELPFUL or CORRECT if it is what you looking for. Thanks

Re: SNAPSHOT MAKER OF QVD

abhaysingh — Wed, 06 Jul 2016 07:23:03 GMT

Hi,

I dont have the date in my table ,

Load Plant, MaterialGroup,Qty from qvd

this is table i have .. dont have date in it..

pls suggest

Re: SNAPSHOT MAKER OF QVD

Wed, 06 Jul 2016 07:30:41 GMT

in that case use today() in the variable to datestamp

Re: SNAPSHOT MAKER OF QVD

tyagishaila — Wed, 06 Jul 2016 07:42:08 GMT

You can use Today() , variable name depends on your requirement,

e.g. below qvd will create on Monthly basis.

LET vDate = MonthName(Num(Date#(Today())));

STORE DataTab into abc_$(vDate).qvd(qvd);

Here QVD will generate with name :

abc_Jul 2016.qvd

Re: SNAPSHOT MAKER OF QVD

abhaysingh — Wed, 06 Jul 2016 12:55:26 GMT

so how it will work in my case?