How to get Maximum date in Load Script

[SatyaPaleti]

Hi Friends,

Need a small help

I am having a field called Receipt date

I want to calculate Minimum Receipt Date only in script

I am using

Load

Min(Receipt Date) as Minimum Date

from xyz.qvd

But it is showing error

could any one of you help how to write this inn script level

Thank you,

Satya

[Chanty4u]

try dis

Load*,

Min(Date(Receipt Date)) as MinimumDate

from xyz.qvd

[marcus_sommer]

Could it be that your load-statement is missing a fileformat like: from xyz-qvd (qvd);

- Marcus

[marcus_sommer]

Further helpful is this: “Fastest” Method to Read max(field) From a QVD | Qlikview Cookbook

- Marcus

[MK_QSL]

Please post screenshot of your script...

[#6]

Try this

Load

          Min(Date([Receipt Date])) AS ReceiptDate

From  xyz.qvd ;

[#7]

Load

          Min(Date([Receipt Date]))     AS     ReceiptDate

From xyz.qvd ;

[engishfaque]

Dear Satya,

Can you share your .qvd file?

I think, you are facing error "invalid expression" due to aggregate function "Min()". Please load one more field and use group by clause.

Kind regards,

Ishfaque Ahmed

[harsh44_bhatia]

maxmindate:

load

DATE(min(FieldValue('dateField',RecNo()))) as minDate,

DATE(max(FieldValue('dateField',RecNo()))) as maxDate

AutoGenerate FieldValueCount('dateField');

this is also one of the way to get the minimum or max date

[vinod2086]

Hi,

try this one may be it will work

=Aggr(Max([Column_name]),ID)

[PradeepReddy]

while using the aggregation functions, you have to  use group clause.

Load Key_Field,

Min(Receipt Date) as Minimum_Date

from xyz.qvd

group by key_Field;