Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Alejandro3
Contributor
Contributor

Filtrar valores Mayores a cierto valor

Alejandro3_0-1651677236920.png

Quiero realizar un filtro que solo me muestre los valores superiores de 10 millones del campo Sumatoria Total

Alejandro3_1-1651677327687.png

Lo he intentado por este lado pero no me deja.

Labels (3)
1 Reply
vinieme12
Champion III
Champion III

that is used to show/hide the entire column, to restrict values in chart you can restrict your dimension as below

 

replace AfiliadoID with calculated dimension like below

 

=aggr(   if( ExpressionFor Suma Totaria, AfiliadoID) > pow(10,6) , AfiliadoID, null() ) , AfiliadoID )

<< then Uncheck Show Null Values for this calculated dimension

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.