topic Re: set the min and max date value in variable in App Development

set the min and max date value in variable

Broly21000 — Thu, 01 Sep 2022 15:30:43 GMT

Hi ,

Hello,
I want to retrieve the minimum and maximum date to store it in a variable, but the variable is empty each time.
can someone please help me

Temp:
LOAD

Min(Date) as MinDate,

Max(Date) as MaxDate

FROM [lib://QlikSense/MyFolder/MyQvd.qvd](qvd) ;

LET vMinDate = peek('MinDate');

LET vMaxDate = peek('MaxDate');

TRACE 'vMinDate'+$(vMinDate);
TRACE 'vMaxDate'+$(vMaxDate);

Re: set the min and max date value in variable

Aurelien_Martinez — Thu, 01 Sep 2022 15:34:37 GMT

Hi,

If you try with more parameter :

LET vMinDate = peek('MinDate', 0);

LET vMaxDate = peek('MaxDate', 0);

Aurélien

Re: set the min and max date value in variable

rwunderlich — Thu, 01 Sep 2022 15:58:45 GMT

It looks like it should work as written. It may be that the Date field is a Text value, not a numeric date value. In that case you will have to convert the Date as you read with

Min(Date#(Date, 'DD/MM/YY'))

where DD/MM/YY is whatever your text date format is.

-Rob

Re: set the min and max date value in variable

SunilChauhan — Fri, 02 Sep 2022 09:11:40 GMT

Temp:
LOAD

Min(Date) as MinDate,

Max(Date) as MaxDate

FROM [lib://QlikSense/MyFolder/MyQvd.qvd](qvd) ;

LET vMinDate = peek('MinDate',0,Temp);

LET vMaxDate = peek('MaxDate',-1,Temp);

TRACE 'vMinDate'+$(vMinDate);
TRACE 'vMaxDate'+$(vMaxDate);

See the attched File as a sample , I am using Inline Table , You Can use pour Qvd.

Re: set the min and max date value in variable

Thanmughi_Sudaroli — Fri, 02 Sep 2022 10:46:12 GMT

Hi,

Please try the below code.

Temp:
LOAD

Min(Date) as MinDate,

Max(Date) as MaxDate

FROM [lib://QlikSense/MyFolder/MyQvd.qvd](qvd) ;

LET vMinDate = peek('MinDate',0,'Temp');

LET vMaxDate = peek('MaxDate',0,'Temp');

Trace $(vMinDate );

Trace $(vMaxDate );

Drop table Temp;

Re: set the min and max date value in variable

oskartoivonen — Fri, 02 Sep 2022 12:59:39 GMT

Assuming you've checked that MinDate and MaxDate fields return an appropriate value, using the Peek()-function outside a LOAD-statement requires that you use all 3 arguments: field_name, row_no and table_name.