Discussion board where members can get started with QlikView.
See Vineeth Pujari ´s solution. I think this is what you are looking for!
It will exact output please check the attached file .
Can you try this
a good read
When should the Aggr() function NOT be used?