Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Felipe02
Contributor III
Contributor III

Responding to specific filters with no "Display Condition" available.

Guys, I have this measure within a KPI, how do I make the KPI change only if I select the specific filters of Month and Year?

I didn't find the "Display Condition" option to apply a "GetSelect".

Felipe02_0-1690578178648.png

 

1 Solution

Accepted Solutions
Felipe02
Contributor III
Contributor III
Author

Guys I found an answer to make the object ignore a specific filter.

Use this expression:

Avg({<Field=>}[MEASURE/FIELD])

 

View solution in original post

3 Replies
BrunPierre
Partner - Master II
Partner - Master II

Try

Avg({1<[Aderencia Geral]={">0"}, Year=P(Year), Month =P(Month)>} [Aderencia Geral])

Gabbar
Specialist
Specialist

Try this:-
Count({1<Month={"$(=Concat(Distinct Month,'","'))"},Year={"$(=Concat(Distinct Year,'","'))"}>}[Aderencia Geral])

Felipe02
Contributor III
Contributor III
Author

Guys I found an answer to make the object ignore a specific filter.

Use this expression:

Avg({<Field=>}[MEASURE/FIELD])