Taking more time to fetch max date from QVD

[hemachandran]

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

[zhadrakas]

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

[Anil_Babu_Samineni]

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');

[rwunderlich]

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