Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

min date selection

hi,

I want to select minimum of the date from 'date' field.

I have tried it from the below expn:

min(date) as min_date

but the problem is it changes with the selection.

So how to select minimum date irrespective of date selection.

any suggestions

1 Solution

Accepted Solutions
perumal_41
Valued Contributor II

Re: min date selection

Hi Vijay,

use this expression.this expression slove ur problem.

min({1}date) as min_date


5 Replies
vaibsonly
Contributor II

Re: min date selection

can u please attach ur app?

pljsoftware
Contributor III

Re: min date selection

Hi,

where do you want to select min(date)? What do you make to do?

If you want to get a variable with the value of min(date) do you make this:

Variables:

Load

          min(fieldDate) as min_date

          ,max(fieldDate) as max_date

Resident FactsTable;

LET vMinDate= Floor(Peek('min_date'));

LET vMaxDate = Floor(Peek('max_date'));

Drop Table Variables;

I hope this help you.

Regards

Luca Jonathan Panetta

PLJ Software

perumal_41
Valued Contributor II

Re: min date selection

Hi Vijay,

use this expression.this expression slove ur problem.

min({1}date) as min_date


MVP
MVP

Re: min date selection

Hi,

AS Perumal said, just create a variable with this expression

=min({1}date)

Since {1} ignores all selections.

Hope this helps you.

Regards,

Jagan.

Not applicable

Re: min date selection

convert the date to number and then apply min function on it..or please attach ur application

Community Browser