topic Re: How to get Maximum date in Load Script in QlikView

How to get Maximum date in Load Script

SatyaPaleti — Sun, 07 Feb 2016 09:12:23 GMT

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

Re: How to get Maximum date in Load Script

robert_mika — Sun, 07 Feb 2016 09:14:24 GMT

Maybe

Min(ReceiptDate)

Min([Receipt Date])

You can not have space between two words.

If that does not help..

What is your error?

BTW:

in subject you have Max but you are using Min.

Feeling Qlikngry?

How To /Missing Manual(25 articles)

Re: How to get Maximum date in Load Script

SatyaPaleti — Sun, 07 Feb 2016 09:17:23 GMT

Hi Robert,

Thank you for reply I am using Min([Receipt Date]) only

but still it shows error

Thank you,

Satya

Re: How to get Maximum date in Load Script

Chanty4u — Sun, 07 Feb 2016 09:25:35 GMT

as mika said is correct.

try this.

Min(Receipt Date) as MinimumDate no space in MinimumDate

Re: How to get Maximum date in Load Script

robert_mika — Sun, 07 Feb 2016 09:26:10 GMT

What is your error?

Re: How to get Maximum date in Load Script

SatyaPaleti — Sun, 07 Feb 2016 09:30:03 GMT

Its Dislaying Invalid Expression

Re: How to get Maximum date in Load Script

SatyaPaleti — Sun, 07 Feb 2016 09:31:06 GMT

Its Displaying Invalid Expression

Re: How to get Maximum date in Load Script

Chanty4u — Sun, 07 Feb 2016 09:36:14 GMT

hi,'

try dis

Load*,

Min(Receipt Date) as MinimumDate

from xyz.qvd

Re: How to get Maximum date in Load Script

SatyaPaleti — Sun, 07 Feb 2016 09:41:17 GMT

I have done the same thing but it is showing invalid exression

Re: How to get Maximum date in Load Script

Chanty4u — Sun, 07 Feb 2016 09:44:45 GMT

can u shre the screen shot of that ?

Re: How to get Maximum date in Load Script

Chanty4u — Sun, 07 Feb 2016 09:46:47 GMT

try dis

Load*,

Min(Date(Receipt Date)) as MinimumDate

from xyz.qvd

Re: How to get Maximum date in Load Script

marcus_sommer — Sun, 07 Feb 2016 09:47:59 GMT

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

- Marcus

Re: How to get Maximum date in Load Script

marcus_sommer — Sun, 07 Feb 2016 09:50:29 GMT

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

- Marcus

Re: How to get Maximum date in Load Script

MK_QSL — Sun, 07 Feb 2016 15:25:42 GMT

Please post screenshot of your script...

Re: How to get Maximum date in Load Script

Sun, 07 Feb 2016 22:39:39 GMT

Try this

Load

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

From xyz.qvd ;

Re: How to get Maximum date in Load Script

Sun, 07 Feb 2016 23:08:57 GMT

Load

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

From xyz.qvd ;

Re: How to get Maximum date in Load Script

engishfaque — Mon, 08 Feb 2016 03:51:32 GMT

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

Re: How to get Maximum date in Load Script

harsh44_bhatia — Mon, 08 Feb 2016 04:39:12 GMT

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

Re: How to get Maximum date in Load Script

vinod2086 — Mon, 08 Feb 2016 07:25:27 GMT

Hi,

try this one may be it will work

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

Re: How to get Maximum date in Load Script

PradeepReddy — Mon, 08 Feb 2016 07:38:30 GMT

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;