Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hemachandran
Partner - Creator
Partner - Creator

Taking more time to fetch max date from QVD

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

Labels (1)
3 Replies
zhadrakas
Specialist II
Specialist II

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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