
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you so much Rob. This Worked. 😄
Have a great day.
Regards,
Jamie
