Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi folks,
I am having QVD which has more than 7 cores records.
I am fetching the max date from that QVD for incremental load.
It takes about 10 Minutes to find the max date and to store to the variable.
Is there is any solution to fetch max date quickly from the QVD.
Thanks
maybe you can order the data in your QVD Generator by date.
Then you can do it like
First 1
Load Date from QVD (qvd);
This thread could also be helpful:
https://community.qlik.com/t5/QlikView-Documents/Optimize-Group-By-Performance/ta-p/1481470
May be you have used Left Join with Max(Date). Can you try this way?
Table:
Load DateField from qvd;
MaxDate:
Load Max(DateField) as MaxDate Resident Table;
LET vMaxDate = Peek('MaxDate', 0, 'MaxDate');
There are a number of faster ways to determine the max date for a QVD. My favorite is to store the value as an extra field: https://qlikviewcookbook.com/2013/08/super-fast-method-to-retrieve-qvd-high-value/ . See the comments to that post for other suggestions as well.
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com