topic Re: Use Direct discovery to find max date in QlikView

Use Direct discovery to find max date

thierrytt1102 — Tue, 06 Jan 2015 12:40:32 GMT

Hi,

I have a large qvd file and I'd like to use incremental load to refresh it.

I need the max date of this qvd file without loading it in the script.

Would it be possible to use direct discovery to find the max date of the qvd or does it work only with like a sql query?

thxs

Re: Use Direct discovery to find max date

agomes1971 — Tue, 06 Jan 2015 12:45:21 GMT

Hi,

yes on your own words...

or does it work only with like a sql query?

Regards

André Gomes

Re: Use Direct discovery to find max date

Anonymous — Tue, 06 Jan 2015 13:07:18 GMT

Hi,

Why cant you try getting the max date into a variable and save it as separate QVD which will have only Max Date, before storing the huge QVD or before dropping the Table after storing it into QVD

Regards

Harsha

Re: Use Direct discovery to find max date

Anonymous — Tue, 06 Jan 2015 13:18:46 GMT

Hi ,

You dont need to load whole QVD you can just load max (updatedate) from qvd. and use that date into your load

LOAD max(Period) as MaxModified FROM Test.qvd (qvd);

Re: Use Direct discovery to find max date

thierrytt1102 — Tue, 06 Jan 2015 13:21:56 GMT

Thx this solution was my alternative 😉

Re: Use Direct discovery to find max date

thierrytt1102 — Tue, 06 Jan 2015 13:23:39 GMT

This was my actual solution but QV still has to load all the values of that field.

thx

Re: Use Direct discovery to find max date

Anonymous — Tue, 06 Jan 2015 13:28:57 GMT

Good That might be better as you said QVD is huge

Re: Use Direct discovery to find max date

mikkeltaylor — Tue, 06 Jan 2015 13:35:19 GMT

I was about to try this today for the same issue

QlikView: Using FieldValue() to get Minimum and Maximum Dates from a Large QVD file | Hyunku's Blog