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

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

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

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 — Fri, 10 Aug 2018 02:53:45 GMT

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/

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 — Fri, 10 Aug 2018 05:26:45 GMT

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,