Finding Min and Max values from big qvd

[#1]

Hi, the straight forward way to find min and max will be something like the code below. My problem is that it in my case takes about 5 minutes to do it on a fast machine. Since my Qvd is a growing file it will take longer and longer. Besides splitting the qvd file, is there a better way to quicker find the min and max values?

tMinMax:
LOAD
min(ID) as Min,
max(ID) as Max,
max(ID) - min(ID) as Range
from 'qvd\BigTable.qvd' (qvd) where DATE > '$(30_days_back)';

Regards, Ludvig.

[disqr_rm]

Check this out. I sure you would love it.

http://qlikviewmaven.blogspot.com/2009/06/quick-load-of-max-field-value.html

[#3]

Hi, I also saw that suggestion. Didn't get it to work together with my example. However, solved the issue another way. Thanks anyway.

[johnw]

Thanks, Rakesh. I hadn't seen or thought of that, so the link made me happy. That approach is now saving a few minutes of time in my longest-loading script, and I'm going to keep an eye out for other opportunities to use it.

[#5]

Thanks Rakesh!

The link is awesome!!!