Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vishnus85
Partner - Creator
Partner - Creator

Please help me to form this set expression

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

2 Replies
Sokkorn
Master
Master

Hi Vishnu,

Not sure you try this yet =Only({$<gift_date = {$(=Max(gift_date))}>} gift_type)

Regards,

Sokkorn

tresesco
MVP
MVP

Try FirstSortedValue() function like:

firstsortedvalue(gift_id, - gift_date)