Very basic question: Aggregated LOAD

[datanibbler]

Hi,

when I want to do an aggregated LOAD with something like >max(Date)<, can I tell QlikView that I want another value from the same line?

I have tried, but unless I add the same condition in some way, I get all the records...

Thanks a lot!

Best regards,

DataNibbler

[jvitantonio · Accepted solution]

Hi, if you use max(date) you can only retrieve the records for that max date. If you explain in more detail what you need I can try to help you.

Ex:

LOAD

MAX(Date) as Date,

Field2

Resident TempTable;

[datanibbler]

Hi,

actually, that's just what I want to do - any other field I define I want only from the record defined by my aggregation - in this instance, from the record with the max_date.

For some reason, it did not work on my machine when I last tried.

Well, I'll file that under the category "weird things", I already have a few of those 😉

Thanks a lot!

Best regards,

DataNibbler