topic Min Date in QlikView

Min Date

Wed, 11 Sep 2013 12:32:41 GMT

Hello,

I've got a table WORKORDER:

ID_W

ID_GROUP

IS_OPENED (Boolean)

DATE

I'd like to get the first date that is still opened by ID_GROUP

May be Can I use Previous or Peek ? I dont know really.

Regards.

DAAM

tresB — Wed, 11 Sep 2013 12:36:49 GMT

In the script?

Max:

Load Max(Date) as MaxDate FROM <> where IS_OPEN='Y'; // or may be IS_OPEN='1'

Let vMaxdate = Peek('MaxDate') ; // now the variable holds the max date

Drop table Max;

Gysbert_Wassenaar — Wed, 11 Sep 2013 17:27:14 GMT

Try this:

MinDate:

Load ID_GROUP, min(DATE) as MIN_DATE

Resident WORKORDER

Where IS_OPENED = 1

Group By ID_GROUP;

If you don't want the minimum date but simply the first date value encountered you can use FirstValue(DATE) instead of min(DATE).

MayilVahanan — Wed, 11 Sep 2013 17:38:53 GMT

Try with firstvalue() function to get the first value for id group.

Load ID_GROUP, FirstValue(DATE) as MIN_DATE

Resident WORKORDER

Where IS_OPENED = 1

Group By ID_GROUP;

Thu, 12 Sep 2013 06:57:25 GMT

Hi Thank

I used First Value

Regards