Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Ignore Filters on All Fields but One - with Equation

I have the following fields: Company, Question, Response, Year.

I am trying to create a gauge that shows the response to a specific question for a specific year.

Here is my equation:
KPI: SUM({$<Question={"Cost"}>}Response)

My min/max bounds are:
Minimum: =MIN({<Question={"Cost"}>}Response)
Maximum: =MAX({<Question={"Cost"}>}Response)

This works fine, but I want to lock my min and max so they don't respond to a filter.  That way I can filter by company and the gauge value will change, but the min and max will not.  However, I still want to filter by year.  I want the 2018YE min value and the 2018YE max value for my min and max. 

I found several methods of attempting this, but none had an equation for the KPI.  I'm sure I'm just messing up my brackets or parentheses somehow, but I can't figure out how to tell my max and min to ignore all filters except the filter on Year. 

Any suggestions would be appreciated.  Thank you!

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Ignore Filters on All Fields but One - with Equation

Hi @Stars ,

Please use below . The expression value will not change based selction on company.

Minimum: =MIN({<Question={"Cost"},Company>}Response)

Maximum: =MAX({<Question={"Cost"},Company>}Response)

View solution in original post

2 Replies
Highlighted
Partner
Partner

Re: Ignore Filters on All Fields but One - with Equation

Hi @Stars ,

Please use below . The expression value will not change based selction on company.

Minimum: =MIN({<Question={"Cost"},Company>}Response)

Maximum: =MAX({<Question={"Cost"},Company>}Response)

View solution in original post

Highlighted
Contributor III
Contributor III

Re: Ignore Filters on All Fields but One - with Equation

That is amazing.  Thank you so much!