This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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!
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,
View solution in original post
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 😉