Filter Exclusion Not Working in Set Expression Chart

[baliyan_vinay]

Hi Experts,

What I want to achieve is to just affect my expression on MONTH_END selection and not any other filters, I read some solutions around this and now my expression looks like this

=Count({1<MONTH_END=$::MONTH_END, Link_Key={"=If(FirstSortedValue({<CANCEL_STOP_FLG-={'-'}>} Distinct CANCEL_STOP_FLG,-date(MONTH_END)) = 'Y',Link_Key)"}> } Distinct Link_Key)

But this does not work somehow, what I also observed is that the identifier is also not working if I remove the 'include MONTH_END' modifier. 

Like this 

=Count({1<Link_Key={"=If(FirstSortedValue({<CANCEL_STOP_FLG-={'-'}>} Distinct CANCEL_STOP_FLG,-date(MONTH_END)) = 'Y',Link_Key)"}> } Distinct Link_Key)

Regards,

Vinay

@tresesco 

[sunny_talwar]

How about this? Does this work with selections and without selections?

=Count({1<Link_Key = {"=FirstSortedValue({1<CANCEL_STOP_FLG = e({1<CANCEL_STOP_FLG = {'-'}>})>} DISTINCT CANCEL_STOP_FLG, -Date(MONTH_END)) = 'Y'"}>} DISTINCT Link_Key)

[baliyan_vinay]

This does not allow any filters to work which is what I needed but I need just one filter to work on the data, the 'MONTH_END', so I have added it like this now but it does not work. 

=Count({1<MONTH_END=$::MONTH_END, Link_Key = {"=FirstSortedValue({1<CANCEL_STOP_FLG = e({1<CANCEL_STOP_FLG = {'-'}>})>} DISTINCT CANCEL_STOP_FLG, -Date(MONTH_END)) = 'Y'"}>} DISTINCT Link_Key)

Thanks for the help!

[sunny_talwar · Accepted solution]

How about this

=Count({1<MONTH_END=$::MONTH_END, Link_Key = {"=FirstSortedValue({1<MONTH_END=$::MONTH_END, CANCEL_STOP_FLG = e({1<MONTH_END=$::MONTH_END, CANCEL_STOP_FLG = {'-'}>})>} DISTINCT CANCEL_STOP_FLG, -MONTH_END) = 'Y'"}>} DISTINCT Link_Key)

[baliyan_vinay]

Okay this has to be applied within each set. Got it now. It worked. Thanks man! Appreciate it.