topic Re: Excluding Selections in a KPI in QlikView

Excluding Selections in a KPI

Livelya — Sat, 16 Nov 2024 19:07:36 GMT

=
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.

Re: Excluding Selections in a KPI

sergio0592 — Thu, 13 Feb 2020 13:33:12 GMT

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

Re: Excluding Selections in a KPI

Livelya — Thu, 13 Feb 2020 14:32:10 GMT

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

Re: Excluding Selections in a KPI

Brett_Bleess — Wed, 11 Mar 2020 14:27:25 GMT

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