topic Finding Min and Max values from big qvd in QlikView

Finding Min and Max values from big qvd

Fri, 21 Aug 2009 21:09:49 GMT

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.

Finding Min and Max values from big qvd

disqr_rm — Fri, 21 Aug 2009 23:18:32 GMT

Check this out. I sure you would love it.

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

Finding Min and Max values from big qvd

Tue, 25 Aug 2009 21:29:35 GMT

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

Finding Min and Max values from big qvd

johnw — Wed, 26 Aug 2009 04:05:54 GMT

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.

Finding Min and Max values from big qvd

Thu, 05 Nov 2009 00:28:09 GMT

Thanks Rakesh!

The link is awesome!!!