topic Finding a max (or min) value in a loaded table in QlikView

Finding a max (or min) value in a loaded table

richard_chilvers — Thu, 27 Feb 2014 11:21:20 GMT

I feel there should be an elegant way to find a maximum value for a field in a table which has been loaded in a script. For example, if I am loading sales of products, can I find the last date something was sold? I do not wish to use PEEK in case the loaded data is not in date order.

Any ideas ?

What I am trying to achieve is an incremental load, based on date.

Thanks in advance.

Richard

Re: Finding a max (or min) value in a loaded table

sujeetsingh — Thu, 27 Feb 2014 11:25:47 GMT

Go to this Blog by Steve

http://www.quickintelligence.co.uk/qlikview-incremental-load/

Re: Finding a max (or min) value in a loaded table

jagannalla — Thu, 27 Feb 2014 11:28:10 GMT

Hi,

Main:

Load * from MainData;

Load Max(Date) as MaxDate Resident Main;

Let vMax=peek('MaxDate',-1,'Main');

Thanks,

Jagan

Re: Finding a max (or min) value in a loaded table

richard_chilvers — Thu, 27 Feb 2014 11:44:43 GMT

Yes - that is elegant. Thank you!

Richard

Re: Finding a max (or min) value in a loaded table

Anonymous — Thu, 27 Feb 2014 13:39:55 GMT

If your Resident data set is large MAX or MIN functions can take a while to resolve.

Here's a useful post on how to optimise this.

Extracting Min(Date) and Max(Date) from large QVD

Re: Finding a max (or min) value in a loaded table

richard_chilvers — Thu, 27 Feb 2014 13:46:27 GMT

Thanks guys.

Sorry to have repeated a question from previous posts, but I didn't pick up earlier answers in my search.

Richard

Re: Finding a max (or min) value in a loaded table

richard_chilvers — Tue, 04 Mar 2014 09:10:41 GMT

Thanks. Its a good post from Steve and he has helped me several times with my queries