Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
baliyan_vinay
Contributor III
Contributor III

Filter Exclusion Not Working in Set Expression Chart

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 

Labels (2)
1 Solution

Accepted Solutions
sunny_talwar

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)

View solution in original post

4 Replies
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
Contributor III
Contributor III
Author

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

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
Contributor III
Contributor III
Author

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