Help with Set Analysis?

qlikuser222 — Sat, 16 Nov 2024 04:16:57 GMT

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

Re: Help with Set Analysis?

juliensaintmaxent3113 — Mon, 04 Mar 2019 15:29:18 GMT

Hi,

in attachment, you find the expression.

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

Bye