How to exclude selection of list item in expression

[#1]

Hi,

I have a following expression, there is a list having FREEZING_REASON_CODE field on the dashboard. I want the resultset not to be changed upon selection of FREEZING_REASON_CODE field. Please help.

=aggr(
FirstSortedValue({<FREEZING_LAST_ACCESSED = {'<=$(=NUM(As_Of_Date))'} >} FREEZING_REASON_CODE , -FREEZING_LAST_ACCESSED)
, FREEZING_PARTICIPANT_ID,FREEZING_ACCOUNT_NUMBER, FREEZING_SECURITY_ID)

[kamielrajaram]

Hi Imran,

Try this

=aggr(
FirstSortedValue({<FREEZING_LAST_ACCESSED = {'<=$(=NUM(As_Of_Date))'},FREEZING_REASON_CODE= >} FREEZING_REASON_CODE , -FREEZING_LAST_ACCESSED)
, FREEZING_PARTICIPANT_ID,FREEZING_ACCOUNT_NUMBER, FREEZING_SECURITY_ID)

[#3]

Hi,

Its not working.

[Anil_Babu_Samineni]

What are you trying to do with your query? Can you explain the rek

[sunny_talwar]

May be this

=Only({<FREEZING_REASON_CODE>} Aggr(FirstSortedValue({<FREEZING_LAST_ACCESSED = {'<=$(=NUM(As_Of_Date))'}, FREEZING_REASON_CODE >}FREEZING_REASON_CODE, -FREEZING_LAST_ACCESSED), FREEZING_PARTICIPANT_ID, FREEZING_ACCOUNT_NUMBER, FREEZING_SECURITY_ID))

[#6]

Hi, Thanks for your reply, but its still not working.

[Anil_Babu_Samineni]

Would you able to share sample qvw

Try this

=Aggr(Only({<FREEZING_REASON_CODE>} Aggr(FirstSortedValue({<FREEZING_LAST_ACCESSED = {'<=$(=NUM(As_Of_Date))'}, FREEZING_REASON_CODE >}FREEZING_REASON_CODE, -FREEZING_LAST_ACCESSED), FREEZING_PARTICIPANT_ID, FREEZING_ACCOUNT_NUMBER, FREEZING_SECURITY_ID)),FREEZING_REASON_CODE)