Discussion Board for collaboration on QlikView Scripting.
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!
Go to 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.
MAX(Date) as Date,
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 ;-)