topic Re: peek min & max functions in QlikView

peek min & max functions

ilanbaruch — Tue, 03 May 2016 08:51:01 GMT

hi, i use min & max function to find min & max date values before calendar build

than put it into a variable with peek

that its more effective to sort the date than peek .. it works for the min but not for the max

tried it like this:

LOAD

DATE

Resident ACCOUNTS Order By DATE desc;

LET varMinDate = Num(Peek('DATE ', 0, 'minmaxdate'));

LET varMaxDate = Num(Peek('DATE ',-1, 'minmaxdate'));

any ideas?

sunny_talwar — Tue, 03 May 2016 08:54:46 GMT

A even better way to do this would be to use FieldValue function. Check out here: “Fastest” Method to Read max(field) From a QVD | Qlikview Cookbook

florentina_doga — Tue, 03 May 2016 08:55:03 GMT

try this

aa:

LOAD

DATE

Resident ACCOUNTS Order By DATE desc;

noconcatenate

bb:

load max(DATE ) as max_data,

min(DATE ) as min_data

resident aa;

LET varMinDate = Num(Peek('min_data', 0, 'bb'));

LET varMaxDate = Num(Peek('max_data ',0, 'bb'));

drop table aa;

ilanbaruch — Tue, 03 May 2016 08:59:05 GMT

thank you, but i'm trying to avoid min & max function

ilanbaruch — Mon, 16 May 2016 10:10:41 GMT

solved with SQL statement directly from the table min & max works good, faster then resident ..

-------

OLEDB CONNECT TO ...

minmaxdate:

SQL

select

max(date) as maxdate,

min(date) as mindate

from orders;