Excluding Selections in a KPI

[Livelya]

=
Count({1<[Ship Date] = {"<=$(_SysCalendarLastWorkingDayCurrYear)>=$(_SysCalendarMonthStart)"},
[LinkId] = {"SHP"}
>}aggr(

IF(Max([SalesLineUDE Notifications: Notified Order Ready])='' or IsNull(Max([SalesLineUDE Notifications: Notified Order Ready])),
IF(IsNull([Shipped Date Actual]),
[Ship Req Num],
IF([Shipped Date Actual]>[Ship Date],
[Ship Req Num])
),
If(Max([SalesLineUDE Notifications: Notified Order Ready])>[Ship Date],[Ship Req Num])),[Ship Req Num]))

I have the above expression calculating the number of Late sales orders however it is not excluding selections.

[sergio0592]

Maybe use 1-$ instead of 1 in Count({1 <

[Livelya]

This did have an effect on my object however I believe this is just excluding the selected value's instead of ignoring all selections.

[Brett_Bleess]

Have a look over the following Design Blog post, believe that should help you confirm things.

https://community.qlik.com/t5/Qlik-Design-Blog/Excluding-values-in-Set-Analysis/ba-p/1471704

If you want to look for other posts in this area, use the following link:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett