Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
jamiemcc
Contributor III

How To Ignore all filters on Calculated KPI's

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

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP

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])

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

View solution in original post

2 Replies
rwunderlich
Partner Ambassador/MVP

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])

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

jamiemcc
Contributor III
Author

Thank you so much Rob. This Worked. 😄

 

Have a great day.

 

Regards,

Jamie