Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

vishnus85
Contributor

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

Tags (2)
2 Replies
Sokkorn
Honored Contributor

Re: Please help me to form this set expression

Hi Vishnu,

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

Regards,

Sokkorn

MVP
MVP

Re: Please help me to form this set expression

Try FirstSortedValue() function like:

firstsortedvalue(gift_id, - gift_date)

Community Browser