Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted
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

Highlighted

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

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)
Highlighted
MVP & Luminary
MVP & Luminary

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