topic Very basic question: Aggregated LOAD in QlikView

Very basic question: Aggregated LOAD

datanibbler — Mon, 03 Jun 2013 09:36:12 GMT

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

Re: Very basic question: Aggregated LOAD

jvitantonio — Mon, 03 Jun 2013 13:35:35 GMT

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;

Re: Very basic question: Aggregated LOAD

datanibbler — Mon, 03 Jun 2013 13:54:42 GMT

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