topic Re: Filter Exclusion Not Working in Set Expression Chart in QlikView

Filter Exclusion Not Working in Set Expression Chart

baliyan_vinay — Sat, 16 Nov 2024 18:47:42 GMT

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

@tresB

Re: Filter Exclusion Not Working in Set Expression Chart

sunny_talwar — Mon, 13 Apr 2020 19:36:51 GMT

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)

Re: Filter Exclusion Not Working in Set Expression Chart

baliyan_vinay — Tue, 14 Apr 2020 08:43:02 GMT

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!

Re: Filter Exclusion Not Working in Set Expression Chart

sunny_talwar — Tue, 14 Apr 2020 11:40:14 GMT

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)

Re: Filter Exclusion Not Working in Set Expression Chart

baliyan_vinay — Wed, 15 Apr 2020 12:06:14 GMT

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