Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;
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