Help with Set Analysis?

[qlikuser222]

Hi all,

I have  requirement where i need to show the amount tagged to a code where the Date is minimum.

I need to display it in text box, but i am unable to unless i made selection in code field.

PFA which has example set for my question.

Thanks

[juliensaintmaxent3113 · Accepted solution]

Hi,

in attachment, you find the expression.

=Sum({<Date = {"$(=Date(min({$<Code={'BBB'}>}Date),'MM/DD/YYYY'))"},Code={'BBB'}>}Amount)

Bye