how to group by concatenated field to use aggregations?

[#1]

Hi

in my Qlikview script i have this:

LOAD
[name]& '-' & [birthdate] as key,
Grade,
year,
Date,

and lots of other fields

So when i use things like min(date) i need to have a group by function, normally i just use "name" to group by but in this table i needed "name" to concatenate with "birthdate" to make it unique... but i just can't use GROUP BY [name]& '-' & [birthdate]; that doesn't work...

somebody knows a solution for this?

[#2]

it's okay 🙂 fixed it myself with some resident loads