topic Re: min date selection in QlikView

min date selection

Mon, 18 Jun 2012 10:51:17 GMT

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

Anonymous — Mon, 18 Jun 2012 11:01:22 GMT

can u please attach ur app?

pljsoftware — Mon, 18 Jun 2012 11:09:31 GMT

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

perumal_41 — Mon, 18 Jun 2012 11:10:46 GMT

Hi Vijay,

use this expression.this expression slove ur problem.

min({1}date) as min_date

jagan — Mon, 18 Jun 2012 11:39:12 GMT

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.

Mon, 18 Jun 2012 12:06:14 GMT

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