Get Max Date selling rate Using set analysis

[muniyandi]

Hi.

How to get Max Date selling rate Using set analysis.partwise ,itemwise.

I select Year or Month

Not Working:

My Expression:

ONLY({<YEAR=,Month=,SalesDate={"=((Aggr(NoDistinct Max(SalesDate),PARTYID,Item)))"}>} Rate)

My sample file attached.Pls hlep.

Regards,

Muni

[whiteline]

Why do you duplicate your questions ?

http://community.qlik.com/thread/61289?tstart=0