How restrict the OLD QVD values in presentation without stopping its job

[Anonymous]

Team,

The Scenario i am handing is:

• I have a QVD is storing every Monday in weekly bases!
• In my enhancement project, now i created new QVD and associated columns of old QVD,(Concatenated)  my now new QVD will run for every monday!
• Now, i need to restrict the data of old QVD in my presentation layer.( to avoid duplication in future) if but we should not stop the job of old QVD!

So how restrict the OLD QVD values in presentation without stopping its job! how to restrict it in Script!

Please provide your suggestions!

Thanks in Advance!

REGARDS,

Ashok Ravichandran,

[Anil_Babu_Samineni]

There is no way to restrict the data from two QVD's But where as you can think to restrict https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

Or

If QvdCreatedTime("Path") = Today() Then

     Load * From Old_QVD;

Else

     // Here Incremental Load involve

     Table_New:

     Load * From Table; // Incremental Load

     Store Table_New into Path.qvd (qvd);

     Load * From New_Old;

EndIf;

[Anonymous]

Hi,

you can create a flag in qvd for ex. QVD_Type:- OLD,NEW.

and then in Data model or UI you can filter data according to your created flag of QVD_Type .

Thanks,