Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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
Partner - Master

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