This content has been marked as final. Show 2 replies
I have a qlikview internal table that contains information like student_id, gift_id, gift_date, gift_type etc.
In a straight table, i need to display against each student_id, the latest gift_date, its corresponding gift_id, gift_type etc.
The latest gift_date of course can be found using max(gift_date). But for its corresponding gift type, what i tried was something like
=if(gift_date=max(gift_date),gift_id) .. and this seems logically wrong.
Can anyone please help me with this?