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

[robert_mika]

Maybe

Min(ReceiptDate)

or

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)

[SatyaPaleti]

Hi Robert,

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

but still it shows error

Thank you,

Satya

[Chanty4u]

as mika said is correct.

try this.

Min(Receipt Date) as MinimumDate    no space in MinimumDate

[robert_mika]

What is your error?

[SatyaPaleti]

Its Dislaying Invalid Expression

[SatyaPaleti]

Its Displaying Invalid Expression

[Chanty4u]

hi,'

try dis

Load*,

Min(Receipt Date) as MinimumDate

from xyz.qvd

[SatyaPaleti]

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

[Chanty4u]

can u shre the screen shot of that ?