Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

datanibbler
Esteemed Contributor

Very basic question: Aggregated LOAD

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

1 Solution

Accepted Solutions
jvitantonio
Valued Contributor III

Re: Very basic question: Aggregated LOAD

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;

2 Replies
jvitantonio
Valued Contributor III

Re: Very basic question: Aggregated LOAD

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
Esteemed Contributor

Re: Very basic question: Aggregated LOAD

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

Community Browser