Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist II
Specialist II

SNAPSHOT MAKER OF QVD

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

11 Replies
Highlighted
Master III
Master III

do you want to see the data in qvd?

Highlighted
Not applicable

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

Highlighted
Specialist II
Specialist II

No i am not using any incremental load till now

Highlighted
Not applicable

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

Highlighted
Specialist
Specialist

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

Highlighted
Not applicable

Yes, using a variable.

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

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

Highlighted
Not applicable

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

Highlighted
Specialist II
Specialist II

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

Highlighted
Not applicable

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