Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

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
Luminary Alumni
Luminary Alumni

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;

View solution in original post

2 Replies
jvitantonio
Luminary Alumni
Luminary Alumni

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
Champion
Champion
Author

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