Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
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?
Regards,
Vishnu
Hi Vishnu,
Not sure you try this yet =Only({$<gift_date = {$(=Max(gift_date))}>} gift_type)
Regards,
Sokkorn
Try FirstSortedValue() function like:
firstsortedvalue(gift_id, - gift_date)