Solved: How To Ignore all filters on Calculated KPI's - Qlik Community

jamiemcc · ‎2021-07-21

Hi Guys,

How do i get my KPI to remain Static if any filters are selected. I dont want my below KPI to change.

Count({1< DateId = {">=$(=Max(DateId))"} >}distinct[Judge ID])/
Count({1}[Authentication Email])

The Date Picker Using the Date Field keeps changing the above KPI.

Regards,

Jamie

rwunderlich · ‎2021-07-21

You are on the right track using {1} to ignore filters. You just need to add {1} in the Max() function.

Count({1< DateId = {">=$(=Max({1}DateId))"} >}distinct[Judge ID])/
Count({1}[Authentication Email])

rwunderlich · ‎2021-07-21

You are on the right track using {1} to ignore filters. You just need to add {1} in the Max() function.

Count({1< DateId = {">=$(=Max({1}DateId))"} >}distinct[Judge ID])/
Count({1}[Authentication Email])

jamiemcc · ‎2021-07-22

Thank you so much Rob. This Worked. 😄

Have a great day.

Regards,

Jamie